October 22nd, 2003, 06:08 PM
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
October 24th, 2003, 12:52 PM
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:
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