1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Rep Power

    monitoring processes from web users

    Being that I'm fairly new to SQL...is there a way to monitor the users that are accessing my database via internet?
    If I go to 'Current Activity'...I will get no info on web users.
    thanks ahead of time
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Woodland Hills, Los Angeles County, California, USA
    Rep Power
    I'm not certain that you're running MS SQL Server, but if you are, then run sp_who from query analyzer to determine the list of connections. To find out the exact SQL statement that a specific connection is running, note down the value of the spid column for that row and then run:
    dbcc inputbuffer(nnn)
    where nnn is the spid for the connection that you're examining.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo

IMN logo majestic logo threadwatch logo seochat tools logo