Column unsage in a DB

• Trooper09

  SSCrazy

  Points: 2047

  More actions

  February 4, 2010 at 9:01 am

  #138665

  All,

  I was wondering if there is a way that I could find out if a column is being by used by any of the stored procedures in a given database..

  So basically the script should scan through each and every SP for a given column and list all the SP's that was using that column....

• Richard M.

  SSCertifiable

  Points: 7401

  More actions

  February 4, 2010 at 9:11 am

  #1113811

  Besides a script, you can use the excellent SQL Search Tool from RedGate (It's Free 🙂 )

  Other than that, you can use this simple query:

  SELECT

  ROUTINE_NAME,

  ROUTINE_DEFINITION

  FROM

  INFORMATION_SCHEMA.ROUTINES

  WHERE

  ROUTINE_DEFINITION LIKE '%YourTextToFind%'

  AND ROUTINE_TYPE='PROCEDURE'

  _______________________________________________________________________
  For better assistance in answering your questions, click here[/url]