views:

171

answers:

1

It's possible to capture a query's result using SQL Server Profiler?

i.e. the resultset generated by the query

+1  A: 

It is not possible to capture the results of a query using SQL Profiler. You can view pretty much everything else though - includung the actual query executed, parameters and their values, query statistics etc.

Barry
I also do not know a way to do it in SQL Profiles. What I do is record the queries and then copy paste them in QA and re-run them. This is not ideal and not always possible but this is the only way I know it would work.
IMHO