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

Answers

Satendra,

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,

Eric

-- Anonymous, February 17, 2005