Hi

To find out which object is referenced by any other use:

SELECT OBJECT_NAME(referencing_id) referencing,

OBJECT_NAME(referenced_id) referenced,

*

FROM sys.sql_expression_dependencies

To find out which procedure uses "CustomerId" use:

SELECT OBJECT_NAME(object_id), *

FROM sys.all_sql_modules

WHERE definition LIKE '%CustomerId%'

To find out which table contains a special word (within its data) there is no build in function.

Greets

Flo