Results 1 to 3 of 3

Thread: [RESOLVED] T-SQL List all cursors

  1. Jul 31st, 2008, 04:51 AM #1
    Abbas Haider
    Abbas Haider is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2006
    Posts
    275

    Resolved [RESOLVED] T-SQL List all cursors

    I want to find all the cursors that has benn declared

    What should I use

    sp_cursor_list???

    Thanks in advance
    Reply With Quote Reply With Quote
  2. Jul 31st, 2008, 06:02 AM #2
    kevchadders
    kevchadders is offline
    Hyperactive Member
    Join Date
    Jan 2008
    Location
    Merseyside
    Posts
    456

    Re: T-SQL List all cursors

    try

    Code:
    SELECT * 
FROM master.dbo.syscursors
    If I've helped, please RATE my post.

    Some Informative Links: [Useful T-SQL Factsheet ] [T-SQL DateTime DataType][10 Most Asked SQL Questions and Answers][Connection Strings Refs]
    Reply With Quote Reply With Quote
  3. Jul 31st, 2008, 11:41 PM #3
    Abbas Haider
    Abbas Haider is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2006
    Posts
    275

    Re: [RESOLVED] T-SQL List all cursors

    Thnx
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width