有什么方法可以看到在sql server中执行的存储过程？ [英] Is there any way through which i can see a stored procedure executing in sql server?

问题描述

有什么方法可以让我看到我的存储过程实际上是如何在sqlserver管理工作室中工作的。当我从业务逻辑层调用存储过程时，我想看看它是如何逐步执行的。它提供了我来自trrigers的结果和视图，我可以看到它是如何运作的。谢谢。

Is there any way by which i can see how actually my stored procedure is working in sqlserver management studio. When i call stored procedure from my business logic layer i want to see how it is execting step by step. It is providing me resul;ts from trrigers and view can i see how it is functioning. thanks.

推荐答案

您可以使用SQL分析器。但这不是一步一步做的选择。它只是根据您的设置捕获所有数据库活动。

You can use SQL profiler. But this not give option to do step by step. It just captures all the DB activity based on your setting.

这篇关于有什么方法可以看到在sql server中执行的存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！