Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

objectid filter in profiler

i want to check any activity related to one table only. i tooks its object id from sysobjects and put it in the filter in profiler, but still is not recognized.. what am i doing wrong?
0
25112
Asked:
25112
  • 3
  • 2
1 Solution
 
25112Author Commented:
does not matter if it is dml or only selects..
0
 
Faiga DiegelSr Database EngineerCommented:
Put it on the TextData like %TableName%
0
 
25112Author Commented:
yes, that worked..

what was wrong with the objectid idea?
0
 
Faiga DiegelSr Database EngineerCommented:
Honestly, I tried it also and it does work for me. I got this link for explanation though: http://support.microsoft.com/kb/303445

Might be helpful...
0
 
25112Author Commented:
ah...so they are saying object_id will not be reliable always, right?

but the "like" does not work exactly..

for example I put the search criteria %PS_EMP%

It does get it often but also things like below which is not exactly the match:

exec sp_execute 416,'Load PS.EMP',0,'2011-09-07 12:12:01','2011-09-07 13:15:17',263117,7905,'KEEP_EMP_SSN'

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now