Database 'XYZ' is Already Open and Can Only Have One User at a Time
Reason:
The reason you are receiving this error is that your DB is set to single user mode.
Solution:
#1 To correct this error go into Enterprise Manager and right click on the DB 'XYZ' and go to Properties, than go to the options tab and uncheck the Single User check box.
#2 If we wish to from a separate connection
a) find who has what connections
exec sp_who
b) Disconnect the SPID which is using database 'XYZ'
kill 53
c) set database back to multiuser
alter database XYZ set multi_user
Reason:
The reason you are receiving this error is that your DB is set to single user mode.
Solution:
#1 To correct this error go into Enterprise Manager and right click on the DB 'XYZ' and go to Properties, than go to the options tab and uncheck the Single User check box.
#2 If we wish to from a separate connection
a) find who has what connections
exec sp_who
b) Disconnect the SPID which is using database 'XYZ'
kill 53
c) set database back to multiuser
alter database XYZ set multi_user
