KICK THEM ALL!!!

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…

1
2
ALTER DATABASE [YourDbName]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

Here is the original link

Posted in SQL