Tuesday, 24 November 2015

Remove “Restricted User” in SQL Server

Remove “Restricted User” in SQL Server
---------------------------------------------------------------
 
Use DatabaseName
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE DatabaseName SET MULTI_USER
GO