-- Rollback any transactions and set db to single user mode
-- ALTER DATABASE [MyDB-DEV-NEW] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server. Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
No comments:
Post a Comment