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