After a while I couldn’t stand anymore the face of Pinal Dave on SQL Authority. I always check a specific thing that I haven’t been able to memorize…(Yes I need that memory allocation for something else, such as dialogs of Star Wars Phantom Menace PC Game) so I copied his article… but OK Pinal I’ll give you the credit…
ALTER DATABASE [YourDbName]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
Here is the original link…