there is a suite of views that you can search the "definition" column from,
for example this might get you started:
select *
from sys.all_sql_modules
where definition like '%myTableName%'
you can use this view to find stuff in the bodies of procedures,functions,trigger bodies or views.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!