如何让 SQL Profiler 监控触发器执行 [英] How to get SQL Profiler to monitor trigger execution
本文介绍了如何让 SQL Profiler 监控触发器执行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个 SQL Server Profiler 跟踪设置来监视在数据库上执行的 SQL.我最近发现跟踪中不包含触发器执行.在查看跟踪的可用事件后,我没有看到任何看起来包括触发器执行的事件.有谁知道如何设置跟踪来监控触发器的执行?
I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look like they would include trigger execution. Does anyone know how to setup a trace to monitor the execution of triggers?
推荐答案
存储过程:- SP:StmtStarting- SP:StmtCompleted
Stored procedures: - SP:StmtStarting - SP:StmtCompleted
这篇关于如何让 SQL Profiler 监控触发器执行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文