03 Apr
Posted by: mitch in: Development, Dynamics CRM
On SQLServerCentral.com tonight, I found a really neat little SQL procedure written by Brian Knight that allows you to disconnect any users currently connected to a specific database.
I needed this script so I could disconnect all of the CRM users so I could perform some maintenance on the CRM databases.
2 Responses
Darrel Miller
04|Apr|2006 1The following command will disconnect all users and make sure that users cannot logon while you are making your changes…
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
You can allow access again with the MULTI_USER option
mitch
04|Apr|2006 2Excellent suggestion! Thanks Darrel.
Leave a reply