开发者

Is there a way in SQL profiler to filter by INSERT statements?

I am trying to identify SQL INSERTS that occur when a record is viewed from a Windows application. In SQL Profiler I have a long list of stored procedures that fire when the record is viewed, however it is very cumbersome to identify the stored procedure then locate the inserts, then find the stored procedure in the object explorer (even with filters).

Is there a way for me to see all SQL commands on a line item instead of a stored procedure? And t开发者_StackOverflow社区hen filter by INSERT statements?

Thanks for any assitance!


Try watching the events SP:StmtStarting and SQL:StmtStarting, include column TextData, and set a Column Filter for TextData with the Like set to %insert%.

This may include some false positives like references to the "inserted" table in a trigger, etc.


Just adding some screenshots to the above answer:

Is there a way in SQL profiler to filter by INSERT statements?

Is there a way in SQL profiler to filter by INSERT statements?

Is there a way in SQL profiler to filter by INSERT statements?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜