How can I add a filter which can trace sql statements for a particular table name?
The Data Profiling task can be used to perform analysis of data patterns within a SQL Server table. This analysis is useful for examining data prior to loading it into a final destination, like a data warehouse.
Double click Database Mail to open the Database Mail Configuration Wizard. On the Select Configuration Task page, select Manage Database Mail accounts and profiles option and click Next. On the Manage Profiles and Accounts page, select Create a new profile option, and click Next.
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]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With