April 15, 2003 at 9:41 am
Can someone tell me how to set my database to single user mode? The problem I am having is that users keep connecting to it and therefore I cannot set the database to single user mode.
Is there a stored procedure or command that will let the locks clear and take it and set it to single user mode?
April 15, 2003 at 10:00 am
You can disconnect the users with the kill command. To kill all the users connected you can check this topic posted before
April 15, 2003 at 10:01 am
Just execute this:-
alter database dbname set single_user with rollback immediate
That will roll back any work currently being done by the users immediately, then place the database into single user mode.
April 17, 2003 at 9:15 am
This alter database statement sounds like it might work in SQL 2000, but it will not work in SQL 7. Is there a similar statement that will work in SQL 7?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply