Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rafal S. Kill all connection to database RE: Kill all connection to database

  • March 8, 2011 at 12:49 am

    #1295713

    i use this:

    ALTER DATABASE Northwind SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    EXEC sp_dboption 'Northwind', 'single user', 'FALSE'