I took over someones job and need to find out from where certain tables are being read. Is there a way to do that? The more information I could get about the caller the better.
I am using MS SQL Server 2000.
A:
If you can get on the server while your table is being accessed, look into the undocumented stored procedure sp_who2.
Michael Petrotta
2010-09-23 22:39:27
I dont know when the table is being accessed.
vikasde
2010-09-23 22:43:03
A:
You might also run a network sniffer process to watch the raw connections.
Alex Howansky
2010-09-23 22:42:46
+1
A:
You could add a trigger to the table you want to be audited and insert relevant data into an audit table from there.
krock
2010-09-23 22:57:22
Triggers won't help if the OP wants to track tables "being read", which I assume means tracking SELECT statements. For that, you need a trace.
Pondlife
2010-09-24 12:53:15
+2
A:
If you want to see the full detail of all queries that are being run against the server, including the hostname and username of the client calling it, you'll want to run a trace.
You can use the SQL Profiler tool to run a short trace, but I prefer to run a "server-side" trace to a file, which I can examine later.
See the SQLServerPedia article here: http://sqlserverpedia.com/wiki/The_Server-side_Trace:_What,_Why,_and_How
BradC
2010-09-23 23:00:09