sql-serverfilteringprofiler

How to profile for one table in SQL Server?


How can I add a filter which can trace sql statements for a particular table name?


Solution

  • You can't set filter to trace specific table directly.

    What you can do is specify a filter for Text Data:

    File -> Properties -> Event Selection -> Column Filters -> TextData -> Like -> [Table Name]

    You may find it important to wrap your table's name with wildcard characters: "%table name%".