SQL Server Performance Forum – Threads Archive
run progI 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.
http://support.microsoft.com/default.aspx?kbid=224587#3 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.