Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Kill all Connections Expand / Collapse
Author
Message
Posted Sunday, September 30, 2007 2:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:41 AM
Points: 155, Visits: 143
Comments posted to this topic are about the item Kill all Connections



Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.
Post #404634
Posted Friday, July 18, 2008 3:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 8:07 AM
Points: 1,366, Visits: 989
We've been using this sproc for quite some time now, but we've been having the occational problem with it.

Today my coleague suggested this:
ALTER DATABASE MyDB
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE

which we're going to try.
Is this wise?

Best regards,
Henrik



Post #536580
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse