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