Fields in a file

Is there a way to find all procedures that use a field in a file?

The file is called carrier and I need to find all procedures that use a field called car_type2
rjackmanwynAsked:
Who is Participating?
 
Kobe_LenjouCommented:
Nope ..

On the other hand, you  could script out all SP's and do a 'find' in the resulting code. If the fieldname is unique in your database that might work.
0
 
Kobe_LenjouCommented:
What kind of file are you referring to?

I suppose you're looking for the dependencies on that given field.

http://msdn.microsoft.com/en-us/library/bb677315.aspx
0
 
rjackmanwynAuthor Commented:
It is a table and yes I am looking for the dependencies
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Kobe_LenjouCommented:
SSMS can get those for you

http://www.devx.com/dbzone/Article/39892
0
 
rjackmanwynAuthor Commented:
This is good, but is there a way to drill down to a column in the table?
0
 
rjackmanwynAuthor Commented:
Thanks there are only about 10 procedures that that use that column, so I can search those.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.