CODE EXAMPLE FOR SQL

sql server manager close connection

//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