Find References to Deleted Field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Fred Nelson (fred_at_smartybird.com)
Date: 06/19/04

  • Next message: David Portas: "Re: Find References to Deleted Field" 
    Date: Sat, 19 Jun 2004 16:00:33 -0400

    Hi:

    I deleted an unrequired field from a record in my database and I obviously
    have some reference to it in one of my 70+ stored procedures. I've been
    through all of them twice - I'm sure its there I just can't find it.

    Is there an easy way to search all stored procedures for a reference - or is
    there a way to get the name of the stored procedure that contains the
    reference (as opposed to just the fact that it is referenced somewhere).

    Your help would be GREATLY appreciated!

    Thanks,

    Fred

  • Next message: David Portas: "Re: Find References to Deleted Field"

    Relevant Pages

    • Re: where should I place stored procedure
      ... The stored procedures need to ... reference several databases. ... > Great database answer huh... ... >> thread not storing user created stored procedures in the master database. ...
      (microsoft.public.sqlserver.server)
    • Re: Quick reference to sp_???
      ... speed of light, we could navigate these rifts to our advantage, and thereby ... that covers the *system* stored procedures that ship with SQL Server, ... I agree this level of reference would be useful, at one point I was trying ... >> I have seen the complete reference in the online books, ...
      (microsoft.public.sqlserver.tools)
    • Re: where should I place stored procedure
      ... Great database answer huh... ... If you upgrade your SQL Server, you *may* have to recreate them. ... database and you wanted to reference it from your Products database, ... > These stored procedures need to access multiple databases. ...
      (microsoft.public.sqlserver.server)
    • Table dependencies lost in Sql server 7.0!
      ... we have lost all the dependencies on a table in our development ... Stored procedures ... and Foreign keys are not working. ... About 15 other tables reference this ...
      (microsoft.public.sqlserver.server)
    • Re: Find References to Deleted Field
      ... Use the below script to search the procedure contents and get the procedure ... This script will search the syscomments system table which hold the ... > have some reference to it in one of my 70+ stored procedures. ...
      (microsoft.public.sqlserver.programming)