How can I add a filter which can trace sql statements for a particular table name?
ua4mk5z41#
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]
Text Data
You may find it important to wrap your table's name with wildcard characters: "%table name%".
nbysray52#
This is how I could do it....
Choose below events in the profiler:
Audit Database Object Access Event
Audit Fulltext
Audit Schema Object Access Event
Make sure to choose Text Data , under columns.
Then under column filters choose:
DatabaseID
ObjectId
sysobjects
ObjectName
2条答案
按热度按时间ua4mk5z41#
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%".
nbysray52#
This is how I could do it....
Choose below events in the profiler:
Audit Database Object Access EventAudit FulltextAudit Schema Object Access EventMake sure to choose
Text Data, under columns.Then under column filters choose:
DatabaseID---> enter specific databaseIDObjectId---> enter specific objectID (select fromsysobjectsfor that specific table)ObjectName---> enter required tablename