Does anyone have a piece of code that takes, as a parameter, for
instance, the name of a table, or field, etc... and looks through system
tables, and returns the name of every object that lists that inputted
table name or field name, etc...



For instance, I could search for a field name, and the code would return
every table that had that field name in it, and ever stored procedure
and view that mentioned that field name...



Adam Blumenfeld






#####################################################################################
Warning:

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which it is addressed. If you are not the named addressee any review, dissemination, distribution or duplication of this e-mail is strictly prohibited. If you have received this email in error, please let us know by e-mail and delete it from your system. Please note that any personal views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

Thank You.
#####################################################################################

MS Sql Server LazyDBA home page