sql server programming: Search field name is All SP -- sql server programming

RE: Search field name is All SP

Ed
12/5/2004 7:05:02 AM

sql server programming:

What I used to do is look a the dependencies of the table object and change
it one by one...

Ed
[quoted text, click to view]

Re: Search field name is All SP

Nigel Rivett
12/5/2004 10:24:36 AM

select object_name(c.id) from syscomments c join sysobjects o on c.id =
o.id and o.xtype = 'P' and c.text like '%myobjname%'

That should get most - will have problems where the name is split across
pages in syscomments.
You probably need to look at views and udf's too.

As a final test recreate the database from scripts and see if there are
any errors.

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***

Re: Search field name is All SP

David Portas
12/5/2004 3:12:58 PM

Use Enterprise Manager to generate a script of all SPs then search and
replace in the script file.

--
David Portas
SQL Server MVP
--

Search field name is All SP

Agnes
12/5/2004 10:53:47 PM

I need to change one field name in One TABLE.,
As I know , there is some SP use that field name, How Can i search that
field name ?
or I need to check it one by one ?
thanks a lot

--
..

Re: Search field name is All SP

Agnes
12/6/2004 11:08:40 AM

Thanks All,
How about Search 'table name' in ALL SP ?

--
..
"Nigel Rivett" <sqlnr@hotmail.com> ???
news:OyCDuev2EHA.3452@TK2MSFTNGP14.phx.gbl ???...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.