(DIR) Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
 (HTM) https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
 (DIR) Return to: Scripts
       *****************************************************
       #Post#: 13--------------------------------------------------
       Removing connections of all users and sessions for a Database
       By: srinivasma_exceldbp Date: February 27, 2014, 1:09 am
       ---------------------------------------------------------
       During Maintenance of databases like restore, reindexing,
       offline ,backup  etc , it may be required to remove current
       existing connections for a particular DB
       sp_lib_killusersDB
       #Post#: 27--------------------------------------------------
       Re: Removing connections of all users and sessions for a Databas
       e
       By: Tarun_exceldbp Date: March 20, 2014, 2:14 am
       ---------------------------------------------------------
       I think we can take the database to "Single User Mode with
       Rollback Immediate" for the same purpose.
       *****************************************************