Single User Mode

Question

Post reply

Single User Mode

Deb Stutters

Old Hand

Points: 320
More actions
January 19, 2005 at 10:20 am

#87446

I put my database in single user mode, then tried to get *myself* into query analyzer.
I get login failed
How can I get myself in to run a DBCC repair
Thanks
Deb

Viewing 8 posts - 1 through 7 (of 7 total)

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

Murali Peter SSC Journeyman Points: 99 More actions · Answer 1

check to make sure you're not logged in with any other connections(Enterprise manager) etc.

Deb Stutters Old Hand Points: 320 More actions · Answer 2

Well I am using enterprise manager to get into query analyzer to run dbcc

I don't know any other way to run my dbcc? Should I figure out how to run it from the dos command line or..?

Thanks

Deb

Deb Stutters Old Hand Points: 320 More actions · Answer 3

Ok - I'm in (o;

It's the simple things!

I went into query analyzer *not* using enterprise manager and I'm fine

THanks

Deb

Michael Ziese-200679 Right there with Babe Points: 789 More actions · Answer 4

For future use you can set the Database in dbo use only, than you never had this problem.

I think it is the better way to do any administration jobs on a database.

Jane Matheson-154829 SSCertifiable Points: 5522 More actions · Answer 5

Once you are in single user mode and then start QA, you have to stop the object browser if you normally have it up. It will use your single connection.

Karen Jackson Say Hey Kid Points: 686 More actions · Answer 6

With re: to single user mode in running dbcc programs. Is there a way to do this thru a maintenance plan without user intervention.

I want to run the integrity check offered in the EM Maintenance plan but have not been able to figure out how to do this. It continually fails since the db is not in single user mode. I want to:

put in single user mode

run optimization/integrity check

then put back in multiple user mode without manually doing the steps myself

Any suggestions?

barsuk SSChampion Points: 12280 More actions · Answer 7

Can't you just create a job, with DBCC CHECKDB('MYDB')?

Make sure you create and output txt file to capture the output (on Advanced Tab)