Post reply

Current cursors

  • March 23, 2004 at 4:36 pm

    #160661

    Hi All

    I'm trying to work out a way to get a list of all currently connected cursors to a database. Can anyone help?

    Greg

  • March 23, 2004 at 5:48 pm

    #500137

    try sp_cursor_list

  • March 23, 2004 at 6:15 pm

    #500144

    sp_cursor_list

    From BOL

    "Reports the attributes of server cursors currently open for the connection."

    Note only returns local cursors for the current connection it is ran on or any Global cursors. I can't remember for sure but I believe that info can only be seen thru Profiler, could be wrong but I can't find anything else and I never needed.

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

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