HELP!: How to start SQL Server in Single User Mode

[Jason parrish]

On page 390 of the Admin Companion for SQL Server 6.0, it tells how
to start sql server in single user mode.
I typed the command:
sqlservr /c /dd:\sql60\data\master.dat /m

It starts up and does all the device checking, but then it sits
there with a prompt. I can't type or do anything else, but
control-break. Then it asks if I want to shut it down.

My question is How do you enter sql commands or dbcc commands while
it's in this state?

Thanks,
Steve

[Chris Smedley]

Try opening another session...either through ISQL or WISQL....the
screen you are seeing is the normal SQL Server booup screen. This
information is normally stored in the log file and because SQL Server
normally starts as a service you do not see this info..

Again...you must use isql or wisql to get into the sql server
itself.....

Also note that you cannot have more than one session at a
time....hence the term single user

[Tim Nichols]

You then can start a single connection interface such as isql.