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