Using MS SQL Profiler in SQL 2000
-
Hi Friends, I want to know is there any way i can use SQL profiler to MONITOR all queries RUN on a PARTICULAR table. I see that there is a way to tracks all queries run a particular DATABASE, but i couldn't find a way to trace queries run on a PARTICULAR table in a database. Even though there is no direct way a Work around suggestion would be great. Thanks a lot for ur help.. Regards, Leela Krishna
-
Hi Friends, I want to know is there any way i can use SQL profiler to MONITOR all queries RUN on a PARTICULAR table. I see that there is a way to tracks all queries run a particular DATABASE, but i couldn't find a way to trace queries run on a PARTICULAR table in a database. Even though there is no direct way a Work around suggestion would be great. Thanks a lot for ur help.. Regards, Leela Krishna
Set a filter on the TextData to be Like %table%.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before. -
Set a filter on the TextData to be Like %table%.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.