SQL Server 2008 trace query and output (record rows) of query execution

I want to programmatically trace and save all queries and outputs (record rows) of queries execution in SQL Server 2008 R2.

I’ve easily implemented a query grace program based on TraceServer class of SMO (Server Management Object) in Visual C#.

However, I couldn’t trace outputs (record rows) of queries execution which are like outputs in the results window in SSMS (SQL Server Management Studio).

How can I trace and save them?


You are aware of the fact you’re posting you question to an NT-KERNEL list??? Completely OT!

Short answer: SQL-Trace doesn’t capture the query results. You can’t do it from Profiler, not by using the system procedures, and also not in the managed API.


WAAAAAY off topic.

Locked. Do not re-post.

Learn what this list is about and respect its rules, please.