Find Store Procs

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  July 31, 2008 at 2:49 pm

  #196386

  How could I find store procs in a database which are using cursors?

  List of store procs in which cursors are being used?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 31, 2008 at 2:54 pm

  #851550

  Use Information_Schema.Routines Routine_Defintion column.

  [font="Courier New"]SELECT

     routine_name,

     routine_type,

     routine_definition

  FROM

     information_schema.routines

  WHERE

     routine_definition LIKE '%cursor%'[/font]

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question