SQL Profiler 能否与查询一起显示返回结果集? [英] Can SQL Profiler display return result sets alongside the query?

问题描述

在 SQL Profiler 2005 中，是否可以在 SQL 跟踪中捕获结果集，以便我可以看到带有结果集的相应查询?...或者只是单向追踪?

In SQL Profiler 2005, is it possible to capture a result set in a SQL trace, so that I could see corresponding queries with result sets? ...Or is it only a one way trace?

谢谢！乔治

推荐答案

不，您无法获得 SQL 跟踪中包含的查询生成的结果集.您只能告诉有关调用的各种统计信息(即执行的查询、持续时间、读取等).

No, you can't get the resultset produced by a query included in an SQL trace. You can only tell various statistics about the call (i.e. the query executed, duration, reads etc etc).

输出参数值记录在跟踪中(如果您解析 TextData)，您可以让它在跟踪中包含行计数信息以及查询.它只是不会向您显示查询返回的实际结果集.

Output parameter values are recorded in the trace (if you parse TextData), and you can get it to include the rowcount info in the trace alongside the query. It just won't show you the actual resultset returned by the query.

这篇关于SQL Profiler 能否与查询一起显示返回结果集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！