Monitoring a specific user's activity...

[mmorancbt]

I have a need to monitor a particular SQL server user's activity. I want to see every query they run against the databse. Theoretically, this user has no write access/read only, to a limited set of data - however, I want to see both from a load and an activity standpoint.

I would like to see what queries are actually run as well.

Thanks.

Matthew Moran (career blog and podcast below)
Career Advice with Attitude for the IT Pro

http://blogs.ittoolbox.com/pm/career

http://techcareerconsult.blogspot.com

 

[jbenson001]

I believe you can use SQL Profiler to do what you want

Jim