sql server manager close connection
snippet in sql

sql server manager close connection

user2504

//This should disconnect everyone else, and leave you as the only user:

alter database YourDb set single_user with rollback immediate
//Note: Don't forget

alter database YourDb set MULTI_USER