result set in profiler

[rkusenet]

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

[Simon Hayes]

"rkusenet" <rk******@sympatico.ca> wrote in message
news:bo*************@ID-75254.news.uni-berlin.de...

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

As far as I'm aware, Profiler can't trap result sets, only SQL sent to the
server, plus the various event types.

Since it's a third-party application, there's probably no good solution to
this - the usual approach would be to re-write the app to use stored
procedures, which could include audit code. That's clearly not an option in
this case, though.

If it's important enough to you, you could perhaps trace the SQL statements,
then replay them against a test copy of the database and capture the result
sets in your own script or tool. Since it's not clear what your aim is, I
have no idea if this is a good approach for you or not.

Simon