disconnect users from sql server -- sql server new users

sql server new users : disconnect users from sql server

Hari Prasad
2/18/2007 2:00:02 PM

Hello,

You will have to do by database wise using ALTER DATABASE command.

ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Thanks
Hari

[quoted text, click to view]

Sam
2/18/2007 5:56:42 PM

how can i disconnect users, by code, from sql server?

thanks

Anthony Thomas
2/19/2007 5:28:32 PM

And the good old KILL command still exists. Be careful not to KILL any
system SPIDs.

--

[quoted text, click to view]

Bob Simms
2/19/2007 11:11:44 PM

[quoted text, click to view]
If it's a particular user you want to disconeect, you can use the kill
command to kill their process.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn