June 17, 2003 at 6:31 am
I am trying to identity through profiler where I am excuting server-side cursors. I have already identified all transact-sql cursors. I am seeing a bunch of sp_cursoropen calls with the names of various stored procedures I have written without transact-sql cursors. We are making calls to these stored procedure through Active X and the OLE DB connection string. Is there a way to distinguish the client cursors and the API server cursors through the output from Profiler? All of the profiler cursor trace events have been turned on?
Patrick Quinn
June 20, 2003 at 8:00 am
This was removed by the editor as SPAM
June 20, 2003 at 10:48 am
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_5lpz.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_80kz.asp
Well going by the microsoft documentation, it seems that the profiler Tracks API based cursors and not TSQL based cursors.
If that is not the case, try using sp_cursor_list in a loop or something.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply