Re: how to refresh objects if a column changes

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

From: Prasad Koukuntla (prasad.koukuntla_at_scapromo.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 17:04:39 -0500

This one has definition for SP and functions. Check out
Information_Schema.Views view for views.

"rajani" <rajani@discussions.microsoft.com> wrote in message
news:3D3D71BD-9074-45FA-8D66-EF6B9B819ABB@microsoft.com...
> thank u Prasad.thats great
> does it return all objects sp,views,fucntions?
> --
> cheers
>
>
> "Prasad Koukuntla" wrote:
>
> > Look at the INFORMATION_SCHEMA.ROUTINES view and perform a wildcard
search
> > in the ROUTINE_DEFINITION column for the column name whose data type
> > changed.
> >
> > "rajani" <rajani@discussions.microsoft.com> wrote in message
> > news:2CC754D5-6E44-4DFA-9CA7-E8520D16BA61@microsoft.com...
> > > Hi friends
> > > I have a column (staffid varchar(5)) in a table staff.it stores our
staff
> > info.
> > > our requirements grown we need to increase column length to
varchar(10).
> > > there r many stored procs,function etc., that r currently using this
> > field.
> > > my question is what is best way to get list of objects that
referencing
> > this column so that i could modify them to reflect new chnage?
> > > --
> > > cheers
> >
> >
> >

Relevant Pages