Post reply

sp_cursoropen + error 16954

  • September 6, 2011 at 10:42 pm

    #247585

    Hi all,

    One of the DB's I have the luck in looking after [build 9.0.5000] is seeing the error/warning -

    Error: 16954, Severity:10, State: 1

    After every sp_cursoropen event.

    I've run numerous traces, in case this was the result of recompiles or some other poor performing SQL - no obvious issues were highlighted.

    Has anyone encounted this issue before?

    Any help would be gratefully received!

    thanks

  • September 8, 2011 at 3:37 am

    #1378426

    As far as I know this message is actually informational--it means the server didn't need to use a cursor to perform the specified operation, it just ran the SQL directly.

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

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