Written by:R Teachout6/27/2008 9:59 PM
Ever need to immediately disconnect users on a database, such as when running a Database Restore? Here's a quick trick.
ALTER DATABASE [Misc_Stuff] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO No go do your Restore.When you are done, you can run the following.(Generally you only do this to restore a database, which automatically gets reset back to multi-user after the restore..) ALTER DATABASE [Misc_Stuff] SET MULTI_USER WITH ROLLBACK IMMEDIATE GO
0 comment(s) so far...
