Post reply

who is connected to my db SQL 2000

  • July 22, 2008 at 11:05 am

    #188471

    How do I find out who is connected to a sql 2000? Is there a query I can run that shows me that 🙂

  • July 22, 2008 at 11:10 am

    #846544

    Try looking in your Management Studio, under Management -> SQL Server logs -> Activity Monitor

  • July 22, 2008 at 11:23 am

    #846551

    Todd, thanks a lot for the quick response. I am trying to do this on SQL 2000, I know the section is for SQL 2005...sorry about that.

    I tried to do what you suggest under SQL 2000 and do not match up.

    Thanks

    Roberto

  • July 22, 2008 at 11:32 am

    #846562

    exec sp_who2

    or

    select * from sysprocesses

    Gail Shaw
    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

  • July 22, 2008 at 11:46 am

    #846573

    Gail, that is exactly what I was looking for. thanks a lot for the help!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply