cursor issue

  • In a stored procedure i am using cursor inside the BEGIN TRY n END TRY... in CATCH block, how can i know the the cursor is open?.. is there any possible to identify whether the cursor is open or not?... any help pls?

  • Look at CURSOR_STATUS in BOL

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply