Quick Way To Find Usages Of Db Objects In Sql Server 2008?

Just like Alt F1 gives you information about any DB object., Is there any quick way to find out at what all places is a particular db object refered to. For instance: -A table us

Solution 1:

The dependencies information is a lot more robust in 2008 than previous versions as you no longer get permanently missing dependency info when creating objects in the "wrong" order.

Stealing the example from Books Online

SELECT referencing_schema_name, 
       referencing_entity_name, 
       referencing_id, 
       referencing_class_desc, 
       is_caller_dependent
FROM sys.dm_sql_referencing_entities ('Production.Product', 'OBJECT');

Solution 2:

It's free, use Red-Gate SQL Search http://www.red-gate.com/products/sql-development/sql-search/

Solution 3:

If you right click on an object in SQL Server Management Studio, there's a 'View Dependencies' feature.

What's the difficulty in getting SQL Search installed on your company machines?