Solved

objectid filter in profiler

Posted on 2011-09-07
5
376 Views
Last Modified: 2012-05-12
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
Comment
Question by:25112
  • 3
  • 2
5 Comments
 
LVL 5

Author Comment

by:25112
Comment Utility
does not matter if it is dml or only selects..
0
 
LVL 15

Expert Comment

by:faiga16
Comment Utility
Put it on the TextData like %TableName%
0
 
LVL 5

Author Comment

by:25112
Comment Utility
yes, that worked..

what was wrong with the objectid idea?
0
 
LVL 15

Accepted Solution

by:
faiga16 earned 500 total points
Comment Utility
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
 
LVL 5

Author Comment

by:25112
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now