How do we set Master database into single user mode : LUSENET : SQL Server Database Administration : One Thread

I want to change the Master databse from existing user mode into single user mode. but I am not able to find the way to do so. Could you please help me out.

-- Anonymous, February 17, 2005



You need to stop the server and restart the server at command prompt with "sqlservr.exe -m". This will put the server in single-user mode.

Hope this helps,


-- Anonymous, February 17, 2005

Moderation questions? read the FAQ