Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Lu (new) Kill ALL Connections To a SQL Database RE: (new) Kill ALL Connections To a SQL Database

  • February 15, 2011 at 6:54 am

    #1287027

    I just do this:

    ALTER DATABASE dbname

    SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    GO

    ALTER DATABASE dbname

    SET MULTI_USER

    GO

    Any advantage or disadvantage over the script?