Solve Restricted User Issue in SQL Server 2005

Simply run the following the commands against the database which is showing as 'Restricted User':

ALTER DATABASE database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE database SET MULTI_USER
GO

Print | posted on Saturday, July 18, 2009 8:19 AM

Comments on this post

Thanks dear :)

Left by Dani on Feb 23, 2010 4:54 PM

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 8 and 8 and type the answer here:

Enter the code shown above: