Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Single User

Author  Topic 

rpc86
Posting Yak Master

200 Posts

Posted - 2006-07-04 : 21:38:12
How to remove the label "Single User" in the database?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-07-04 : 23:09:25
Yoy can use the ALTER DATABASE statement.

You can see the format in SQL Server Books Online.


CODO ERGO SUM
Go to Top of Page

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-07-04 : 23:09:58
In Enterprise Manager, right click on the database and select 'Properties'.
Go to the Options tab and unselect 'Restrict Access'

Should fix it.

HTH,

Tim
Go to Top of Page
   

- Advertisement -