This script closes all connections to MS SQL database
USE master; GO ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE dbName SET MULTI_USER; GO
Skill to do come from doing…
This script closes all connections to MS SQL database
USE master; GO ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE dbName SET MULTI_USER; GO
I didn’t know where to find this info then kbaoom it was here.