Written by:R Teachout
6/27/2008 9:59 PM

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

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel