February 29, 2008 at 10:51 am
I'm new to this forum, and fairly new to SQL and Server 2005. Does anyone know of a way to search for fields used in a collection of stored procedures? So, for example, I have field [Id_Name] and want to search all sprocs for that field to see where it's being used.
Thanks!
February 29, 2008 at 11:52 am
I script them to a text file and press Ctrl+F
February 29, 2008 at 1:38 pm
You can use
Select * from syscomments
where text like '%id_name%'
-Roy
February 29, 2008 at 8:00 pm
Thanks... I'm in an environment with lots of databases, so I had to narrow it down, but I got it with a variation of the syscomments query. I probably didn't phrase by question correctly. Anyway, I appreciate it!
February 29, 2008 at 8:02 pm
There is also a free tool out there called SQLDigger that will do exactly what you are asking. http://sqldigger.bdsweb.be/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply