(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. *****************************************************