/* 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,

    OBJECT_NAME (referencing_id) AS ObjectUsingLinkedServer

FROM sys.sql_expression_dependencies

WHERE referenced_database_name IS NOT NULL

AND referenced_database_name='database name'