Friday, February 13, 2015

SQL Server How to Drop Connections

ALTER DATABASE dbname
 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE dbname
 SET MULTI_USER
GO

No comments:

System Design Interview Preparation: A Comprehensive Guide for US Business Leaders

System Design Interview Preparation Understanding System Design Interviews What is a System Design Interview? A system design inter...