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 2:37 am

    #1286924

    If you are attempting to get the db into single user mode, you can use.

    ALTER DATABASE db_name

    SET SINGLE_USER

    WITH ROLLBACK IMMEDIATE