December 11, 2008 at 3:39 am
I just want to know, which table of the database is being accessed by my application interface as I login there.
Can anybody help me with a step by step query through SQL Profiler.
December 11, 2008 at 3:42 am
You can do this by opening a default trace on the profiler, run the profiler and then your appication, you can see the username and the host name from where the data is been accessed, for more information search for Profiler on SQL server Central 🙂
December 11, 2008 at 5:12 am
That is actually the help I need.
When I run the profiler a lot of junk information scrolls through the screen, however, I just want to filter my profiler on the tables only.
December 11, 2008 at 6:58 am
You can't really filter by table in a trace. You can filter by database, which should help. You can also filter by user, which again will help. After that, you need store the trace off to a table (capture it to file, it's more efficient) and you can query the textdata field to find the information you're most interested in.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply