Can I get the result of a query using SQL Server Profiler?
i.e. query generated result
Unable to retrieve query results using SQL Profiler. You can view almost everything else, including - including the actual query, parameters and their values, query statistics, etc.
You need to create a new sql trace, and in the event tab of the new trace de-select everything and select only sqlstmntstarting, sqlstmntcompleted.
, spstarting, spcompleted