Capture query results using SQL Server Profiler

Question

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

i.e. the resultset generated by the query

score 5 · Accepted Answer · answered Apr 27 '10 at 06:35

5

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.

answered Apr 27 '10 at 06:35

codingbadger

42,678
13
95
110

2

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 Apr 27 '10 at 13:30

score -1 · Answer 2 · answered Mar 05 '12 at 07:28

-1

You need to create a new sql trace , and while doing that in the events tab of new trace de-select all and select only sqlstmntstarting, sqlstmntcompleted.

if you want to monitor procedures as well spstarting, spcompleted

answered Mar 05 '12 at 07:28

saianirudh

104
5

Capture query results using SQL Server Profiler

2 Answers2