SQL Server 2005 - sp_cursorfetch

I had been grumbling for a long time about sp_cursorfetch in SQL Server profiler.

The only way to find the SQL statement associated with the query is to locate an entry for sp_cusroropen. So if I open the profiler where sp_cursoropen has alerady been executed then tough luck.

I found a way to figure out the SQL statement associated with sp_cursorfetch. Note that this methodology is very expensive so if you try this on the live system then put in some filter for spid, databasename etc.

I am not going to go into a lot of details. Everything will be clear from this screenshot.

Send mail to harry@systomatics.com with questions or comments about this web site.

Disclaimer: I am working with Microsoft Business Solutions. The code on this site may or may not be related to my official duties with Microsoft. I do not claim in any expertise in modules represented on this website. Essentially there is just one person doing functional specifications (in head), design specifications (in head), coding and some testing. There is no way the project on this site will be free of bugs. The projects are intended as guidelines and may god help you if you decide to implement the projects without making any changes. If you implement any project resulting into data corruption or anything like that then do not even think of suing me because a. I have already warned you and b. I don't have any money. I may or may not respond to your emails about supporting the project. I may or may not upgrade the projects to the next service pack / version.