Script to check Link server name in View and Store Procedure

--Script to check Link server name in View / SP 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 in ('YourLinkServerName') ---Script to check Link server in SQL Server 2005 SELECT OBJECT_NAME(object_id), * FROM sys.sql_modules WHERE definition LIKE '%YourLinkServerName%'