I'm doing some work on some servers and need to reboot them remotely via remote desktop.

SQL is one of those things i've never had to learn, short of installing it and configuring memory usage limits.

How do i tell if someone is logged in to the sql server (SQL2000) databases before i shut the thing down? Surely there must be somewhere in Enterprise Manager i can look?

I doubt there is anyone using it with it being saturday night but just to play it safe i'd rather check for myself

Cheers

Dave

 

Not at work so working from memory on 2000

Under management you can see active sessions (I think).

Or do a sp_who in the master database using analyser. This should tell you if anyone is logged in and using, and what they are using.

 

Sorted it now, cheers