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

NTDEV
1

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?

2

Hi!

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.

GP

3

WAAAAAY off topic.

Locked. Do not re-post.

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

Peter
OSR