Anil Singh | Code-sample.com

 /* How can I tell what database/procedure is using a linked server? */ /* How to check if MS SQL Server, Linked Server object is in use */ /************** Example 1  *********************/ SELECT      Distinct      referenced_Server_name As LinkedServerName,     referenced_schema_name AS LinkedServerSchema,     referenced_database_name AS LinkedServerDB,     referenced_entity_name As LinkedServerTable,     OBJECT_NAME (referencing_id) AS ObjectUsingLinkedServer FROM sys.sql_expression_dependencies WHERE referenced_database_name IS NOT NULL And referenced_Server_name = 'Linked Server Name' /************** Example 2  *********************/ SELECT DISTINCT      referenced_Server_name AS LinkedServerName,     referenced_schema_name AS LinkedServerSchema,     referenced_database_name AS LinkedServerDB,     referenced_entity_name AS LinkedServerTable,   ...