InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:21:48 GMT20http://www.sqlservercentral.com/Forums/Topic404641-760-1.aspxhi,its soo helpful script for me. so simple to run. really appreaciatable.thxsreejithMCADWed, 23 Jan 2008 14:23:09 GMTSreejithsqlhttp://www.sqlservercentral.com/Forums/Topic404641-760-1.aspxYou neglected to include the net send logic.Mon, 22 Oct 2007 08:59:52 GMTCharles Deatonhttp://www.sqlservercentral.com/Forums/Topic404641-760-1.aspxFor my case, after I kill user connections by using this kind of stored procedure, our application re-connects to database right away. I believe that it is the good choice to put your database in single user mode.Fri, 05 Oct 2007 10:17:06 GMTrw_eboxhttp://www.sqlservercentral.com/Forums/Topic404641-760-1.aspxNice stored procedure to kill processes but I don't understand when you would use it?If you need everyone out of a database and need them to stay out, then I'd use:ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH ROLLBACK AFTER n SECONDSdo maintenance tasks hereALTER DATABASE [MyDatabase] SET MULTI_USERWhile the maintenance tasks are running, no one else can connect.If you need to restrict it to admins only, then use RESTRICTED_USER instead of SINGLE_USER.Just a thought,JoeFri, 05 Oct 2007 07:33:23 GMTJoe B-478020http://www.sqlservercentral.com/Forums/Topic404641-760-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Lock+and+Connection+Management/31966/">usp_KillConnections</A>[/B]Sun, 30 Sep 2007 04:01:10 GMTAntonio Pedrosa