Click to See Complete Forum and Search --> : SQL Server Stored Procedure


Gopinath
06-21-2003, 04:13 AM
I have almost 600 SPs in my database.
I have the field name called phone and its datatype varchar(10).
Now i want to change the datatype to varchar(15).
I want to change all the SP name which are reflected by the change
Any SQL query to identify all the SP's having a string
thanks

PeOfEo
06-21-2003, 11:08 AM
Is that a question or a statment or what?