Change database permission 2

[gatetec]

// SQL Server 2000

A database is on 'Single User' mode, i.e. HRPERKDB (Single User). How do you change it to "multi-user mode" where you don't see 'Single User' so that it just say 'HRPERKDB'.

thx much

 

[Ovatvvon]

Gate tec,

Right click on the database (HRPERKDB), then select properties. When the dialog window opens, go to the OPTIONS tab along the top. Once there, in the first section, you will see two check boxes, Restrict Access and Read-Only. You're Restrict Access checkbox is checked with the Single-User radio-button checked. Uncheck the Restrict Access checkbox and click ok. You should be good to go.

-Ovatvvon :-Q

 

[gatetec]

I am getting an error - "'HRPERKDB' in already opened and can have only one user at a time". How do I get around this issue?

thx much

 

[Ovatvvon]

Recycle SQL Server and make sure you get the first connection...(or wait for the existing connection to end).

-Ovatvvon :-Q

 

[gmmastros]

Open Query Analyzer
Set the database to [blue]MASTER[/blue]

Run this command

ALTER DATABASE [HRPERKDB] SET MULTI_USER WITH NO_WAIT

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gatetec]

thx so much.
"ALTER DATABASE [HRPERKDB] SET MULTI_USER WITH NO_WAIT" works handy.