Drop all Connections from a Database

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  September 29, 2007 at 8:20 pm

  #70769

  Comments posted to this topic are about the item Drop all Connections from a Database

• noelpv

  SSC Journeyman

  Points: 92

  More actions

  June 12, 2008 at 12:38 pm

  #828057

  I use this:

  ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE