Saturday, December 14, 2013

SQL - Remove Restricted Mode on Databases

ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE DatabaseName SET MULTI_USER
GO
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)