SQL Server >> SP_CURSOREXECUTE

by Bonato Pierantonio » Fri, 13 Feb 2004 05:33:08 GMT

Hi All,
can anyone help me???
I have an application that access my SQL Server. When I debug it with
Profiler I saw a line like this:
EXEC SP_CURSOREXECUTE xx,......

How can I Know which T-SQL command generate this execution?

Thanks
Bonato Pierantonio



SQL Server >> SP_CURSOREXECUTE

by Andrew J. Kelly » Fri, 13 Feb 2004 06:10:30 GMT


Follow the SPID up or down (depending on what events you are catching) and
you should see the statement that is executing. This is usually the result
of a client creating a Server side cursor to loop thru the rows one by one.
Not a very efficient way of doing things.

--

Andrew J. Kelly
SQL Server MVP

SQL Server >> SP_CURSOREXECUTE

by Bonato Pierantonio » Sat, 14 Feb 2004 01:22:57 GMT

I try to look Up and Down but I do not find any T-SQL command???
How can see it?

Thanks
Bonato Pierantonio

"Andrew J. Kelly" < XXXX@XXXXX.COM > ha scritto nel messaggio

result
one.

SQL Server >> SP_CURSOREXECUTE

by Andrew J. Kelly » Sat, 14 Feb 2004 02:05:03 GMT

Maybe you don't have the right events being traced but somewhere there has
to be a select, or stored proc call.

--

Andrew J. Kelly
SQL Server MVP





and