How to Remove “Restricted User” in SQL Server

 Use below mentioned code for resolving this issue.

Use [SQLDBANOW]

ALTER DATABASE [SQLDBANOW] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [SQLDBANOW] SET MULTI_USER

GO

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)