anyone know sql? i need to disconnect users

_Jimlad_ · 21 Jan 2011 at 17:41

im trying to upgrade a database remotely and some silly bugger is logged in. i have a tool that we use for this purpose however its not working, i need to kill the connections to the database but cant seem to see it.

using sql standard 2008

_Jimlad_ · 21 Jan 2011 at 17:52

Pho said:
Right click the database and go to properties. Then go to the options section and at the bottom set restrict access to single_user; it'll kill all connections apart from yours. Set it back to multi_user when you're all done (if it doesn't do it automatically).

thank you. is this in Studio management?

_Jimlad_ · 21 Jan 2011 at 17:59

Pho said:
Sorry, yeah it is .

nice one! i have found it!

cheers mate

_Jimlad_ · 21 Jan 2011 at 18:07

thanks mate, will make note of that!