Thanks for the quick reply. But the problem still is I cannot login to the SQL db at all because it's in Single-user mode, so how can I execute a SQL select statement if I cannot login???
You don't need to connect to that database. Run it from any database on that instance. Run it from master. sysprocesses is a server-wide view, you'll get exactly the same results from it no matter what database you run it from.
If I could execute a select statement to look at the sysprocesses I would be able to execute the Alter database command to set it to Multi-User mode.
No. If that was the case I wouldn't be telling you to query sysprocesses. All you need to query sysprocesses is a connection to a database, any database. Master's fine. So all you need to be able to do is log into the instance.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass