SQL Server 2005 search views for certain database objects -

Is there a list of all the ideas in the database that connects to a particular object in SQL Server?

i.e.: All ideas that link to myTable

You can use : Select

  object_name (object_id), * sys.sql_dependencies from where referenced_major_id = object_id ('& lt; tablename & gt;');  

This will list all the objects dependent on your table, you can restrict it by seeing it in the opposite:

  select v. Joining D from Sys.sql_dependencies to d.object_id = v.object_id on sys.views v where referenced_major_id = object_id ('& lt; tablename & gt;');