Results 1 to 1 of 1
Feb 7, 2006, 23:12 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
how to search a string in existing Stored Procedure, views, jobs
I was given an application which doesnot have a documentation.
It is done in asp using SQL2000.
I have no idea where and how the column, tables are effected.
I can make a global search for the table or column name in asp to find out the flow to some extent.
but how can i make a search for perticular table name in all the existing stored procedures,views,jobs ???
cuz most of the transactions are inside the SP and i want to find them all in single search.
Is there any option in SQL like find/find all where i can make a search?
any other way??
Last edited by Bruce Lee; Feb 21, 2006 at 23:28. Reason: typoHappy Coding!!!