>Is there any way that I can browse the results of a cursor in a stored procedure. I am using Declare temp_Cursor CURSOR SCROLL FOR select * from temptable
>then after the cursor is executed I would like to browse the result set so I can make sure the data is accurate.
>
>Thanks for you help !
>Stephen J. Hunt

Stephen,

The SQL tools (QA, EM, and SSMS) do not include a cursor browser. What you can do is place a 'select * from temptable' command into the procedure or script immediately before the OPEN CURSOR command to see the same result set that the cursor will use. In QA or SSMS the result set will be displayed in the results pane and you can scroll through it.