I was just reading this SO thread and had a question for @Mack regarding whether there is a way to check if a SQL object is referenced by any other SQL objects.
He (@Mack) used T-SQL and DMVs to accomplish something similar in his answer.
Is this possible, if so how?
I would have posted this as a comment, but I don't have sufficient reputation yet...
You can, but not with a DMV instead you'll need a related dynamic management function(DMF) dm_sql_referencing_entities
(more info here).
Here is the code:
SELECT referencing_schema_name
, referencing_entity_name
FROM sys.dm_sql_referencing_entities ('*schemaname.objectname*', 'OBJECT');
Here's a link to the MSDN page on DMVs and DMFs.