run prog | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

run prog

I need to run a profiler for any UPDATE that may ocur on a table of a database, … and only to that table.
What filter should I use? I tryed the Object ID LIKE , that I got from a SELECT * FROM SYSOBJECTS from my database, but it gets all transactions, and not only for that table.
Hi ya you can filter the text column to be like %UPDATE%<tablename>% replacing <tablename> with your table’s name Cheers
On the filters I only have TEXT DATA, and using %UPDATE%<tablename>% doesn´t return me nothing
I suggest to trace all what you need, save in file and then try filtering like Twan said. This way you can "play" differents filters to find what you need.
Luis Martin
Moderator for reference on Profiler and also search under this site for further tips and tricks. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.