Undo single user mode

Question

Post reply

Undo single user mode

Choumphol Bounthinh

SSC Enthusiast

Points: 168
More actions
July 14, 2005 at 3:53 pm

#90106

I started sql server in a single user mode from the enterprise manager. Later I can't connect into it. Is there a way to undo the single user mode from a command line?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ND-215452 SSCrazy Points: 2037 More actions · Answer 1

I think it goes something like this:

use master

go

exec sp_dboption dbname, 'single user', false

go

--check point

use dbname

go

checkpoint

go

CJohnson-232084 Default port Points: 1492 More actions · Answer 2

sp_dboption is still around for backward compatibility. Microsoft now recommends using ALTER DATABASE.

You should read BOL about the options and the effect of this operation on your database, especially what happens to users connected to the database when you execute the comman.

Now, for the short answer this will do what you need:

ALTER DATABASE test SET SINGLE_USER

HTH

gbn SSCertifiable Points: 6429 More actions · Answer 3

Did the poster not say "...started sql server..."

Not a database...

Unless they meant a database...

Can you not connect to sql or can you not connect to a database?

Choumphol Bounthinh SSC Enthusiast Points: 168 More actions · Answer 4

You know that the reason I could not use the EM to connect was because my sqlagent service was running (that one connection right there). After stopping the sqlagent serivice, I was able to use my EM to disable the single user mode.

Thanks to you all!