Sunday, May 30, 2010

How to Remove Restricted User in SQL Server 2005

The problem is that the database is in a single user mode, this usually happens after a restore process.

You have to execute the query below to change it back to multi user mode by executing the query below.

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

No comments:

Post a Comment