2012年3月19日星期一

disconnect the user

I'm trying to detach my database.But i couldn't do that coz there are some users connected to it. So how can i disconnect them?is there any way to disconnect them from the DB?
Thanks.In SQL server 2000

When you detach a database it should give you an option to kill all user processes, if you click that it will log off all users.

If not I have some t-sql code that does it.|||It worked fine.Thank you very much.

没有评论:

发表评论