Kill all Connections

• Justin-14543

  SSCrazy

  Points: 2017

  More actions

  September 30, 2007 at 2:57 am

  #175386

  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.

• Henrik Staun Poulsen

  SSCertifiable

  Points: 6580

  More actions

  July 18, 2008 at 3:42 am

  #844875

  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