Originally Posted by Sarconia KB96140 for SQL Server 2008, it's effectively the same process, just that it looks different to 2005.
Originally Posted by siuko This is from supportnet - KB88695 - It stops poeple connecting to the sims server... except the server itself (I have the sims client installed on the server to test with)
How to force Users out of Sims.net KB88695
THIS SOLUTION CANNOT BE USED FOR HOSTED SQL INSTANCES
The following workaround will terminate any current connections to the SIMS SQL Instance, and if users are actually using SIMS .net, this will force them out.
Any unsaved changes will be lost.