Disconnect / Kick All Users from MSSQL Server Database



Share this article :

MSSQL Server Management Studio

Use MSSQL Server Management Studio to set the database into single user mode. Click Yes to disconnect all the users.

Disconnect MSSQL Users SQL Studio

Command Line

Execute below command.

ALTER database DATABASE-NAME SET SINGLE_USER with ROLLBACK IMMEDIATE;

Nonqualified transactions are being rolled back. Estimated rollback
completion: 100%.

Related posts

SAP Tools for MS SQL Server (STM)
Find Last Database Backup & Log Backup for MSSQL Server
How to Enable MSSQL Backup Restore to Mapped Network Drive
How to Activate xp_cmdshell Server Configuration Option
© 2017 ITsiti. All Rights Reserved
Powered by KEEM