SQL 6.5 and Single User Problem

[Reiner]

I use SQL 6.5 and Service Pack 5a NT4 with a CLuster and Raid.

One DB (DB1) is in SIngle User and Read Only Modus. If I use the Enterprise Manager to máke a new Login and/or to change the rights of another DB, I get the message, that DB1 is in single user Mode:

Error 924: ... DB is in Single User MOde....


The same message was sent, if I use I-SQL and ask DB1 with a DBCC or SP ():

dbcc checkdb (db1):
Nachr.-Nr. 924, Schweregrad 14, Status 1
Database 'DBPLW02' is already open and can only have one user at a time.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

or with sp_dboption dbplw02, offline, true:

Nachr.-Nr. 5160, Schweregrad 16, Status 1
Cannot take 'dbplw02' offline because usecount=1.
Nachr.-Nr. 15245, Schweregrad 16, Status 1
'DBCC DBCONTROL' error. Database not placed offline.

I can´t change the DB1 in multi user mode and I can´t find the person who has opened DB1 because I get every time this message.
Technet only tells problems with the Enterprise Manager and not with EM and I-SQL!

Who can help?


Reiner

[Craig]

Why don't you use sp_who and kill the user on that database, or bounce the server and do it then?


------------
Reiner at 5/26/00 2:17:39 AM

I use SQL 6.5 and Service Pack 5a NT4 with a CLuster and Raid.

One DB (DB1) is in SIngle User and Read Only Modus. If I use the Enterprise Manager to máke a new Login and/or to change the rights of another DB, I get the message, that DB1 is in single user Mode:

Error 924: ... DB is in Single User MOde....


The same message was sent, if I use I-SQL and ask DB1 with a DBCC or SP ():

dbcc checkdb (db1):
Nachr.-Nr. 924, Schweregrad 14, Status 1
Database 'DBPLW02' is already open and can only have one user at a time.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

or with sp_dboption dbplw02, offline, true:

Nachr.-Nr. 5160, Schweregrad 16, Status 1
Cannot take 'dbplw02' offline because usecount=1.
Nachr.-Nr. 15245, Schweregrad 16, Status 1
'DBCC DBCONTROL' error. Database not placed offline.

I can´t change the DB1 in multi user mode and I can´t find the person who has opened DB1 because I get every time this message.
Technet only tells problems with the Enterprise Manager and not with EM and I-SQL!

Who can help?


Reiner

[Reiner]

Hey Craig,

thanks for the tip, off course, that was to easy, but it was the answer...

Reiner


------------
Reiner at 5/26/00 2:17:39 AM

I use SQL 6.5 and Service Pack 5a NT4 with a CLuster and Raid.

One DB (DB1) is in SIngle User and Read Only Modus. If I use the Enterprise Manager to máke a new Login and/or to change the rights of another DB, I get the message, that DB1 is in single user Mode:

Error 924: ... DB is in Single User MOde....


The same message was sent, if I use I-SQL and ask DB1 with a DBCC or SP ():

dbcc checkdb (db1):
Nachr.-Nr. 924, Schweregrad 14, Status 1
Database 'DBPLW02' is already open and can only have one user at a time.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

or with sp_dboption dbplw02, offline, true:

Nachr.-Nr. 5160, Schweregrad 16, Status 1
Cannot take 'dbplw02' offline because usecount=1.
Nachr.-Nr. 15245, Schweregrad 16, Status 1
'DBCC DBCONTROL' error. Database not placed offline.

I can´t change the DB1 in multi user mode and I can´t find the person who has opened DB1 because I get every time this message.
Technet only tells problems with the Enterprise Manager and not with EM and I-SQL!

Who can help?


Reiner