Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 663
Dakmaz Avatar asked Nov 02 '10 09:11

Dakmaz


People also ask

What is profiling table in SQL?

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.

How do I create a SQL profile?

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.


1 Answers

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]

like image 110
Damian Leszczyński - Vash Avatar answered Oct 09 '22 03:10

Damian Leszczyński - Vash