Trace queries with SQL Server Profiler
- Launch SQL Profiler and connect to the SQL server
- Go to Events Sections and check "Show all columns"
- Click "Column Filters" button
- On
DatabaseName, put your database name or %DBName% for wildcards
- On
TextData and put in "
%TableName%" or/and "
%OtherCriteria%". You can place as many as you want.
- Press OK to close "Edit Filter" dialog and press Run
- Do not forget to stop trace.