result set in profiler  
Author Message
aga2957





PostPosted: Top

SQL Server >> result set in profiler

For debugging purposes we are profiling a particular connection.
We are using a third party software and we want to know what
queries they send to our database and the result set that is
passed back to the client program.

Profiler is helping us with all the information we want, except the
result set which is passed back to the client.

For e.g. if the program issues the following sql

select emp_name from employee_master where dept_code = 582.

and the result is

JOHN DOE
MEG ROSS

We want JOHN and MEG to be captured by the profiler. How do we achieve
that.

Thanks.


--

email id is bogus

SQL Server41