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.