cursor issue

• BeginnerBug

  Hall of Fame

  Points: 3539

  More actions

  November 24, 2010 at 2:52 am

  #231592

  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?

• Mark Cowne

  One Orange Chip

  Points: 26865

  More actions

  November 24, 2010 at 3:02 am

  #1254957

  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