jay Bukstein


I have a question, Does anyone have a TSQL command the will log off ALL users connected to s specific database. The reason I ask is I have a database the needs all users logged off so Rules update can run.

The package I'm speaking of is Compulaw a court docketing database application, the system now performs a rules set update every morning, but will only run when no one is connected to that database. Any ideas

jay




Re: Users failing to log off there Database


Re: Users failing to log off there Database

Chris Howarth

You could switch the database to single user mode to perform the rules update - see here:

http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=2338181&SiteID=17

Chris







Re: Users failing to log off there Database

jay Bukstein

Thank you, this will work for my needs.

Jay Bukstein