SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE | Journey to SQL Authorit

the post is for case when two or more people are using or executing a query in a single database at the same time, sql is such that u cannot delete a database when it is in use, u have to set the db to single user mode from the multi user mode so that u w

blog.sqlauthority.com