Finding Stored Procedures that use linked servers

Is there any way to find all stored procedures that use linked servers or a specific linked server?

[99 byte] By [Milo123] at [2007-12-17]

# 1

For specific it's easy:

SELECT name FROM sys.procedures

WHERE object_definition(object_id)

LIKE '%specific_server_name%'

wrote in message

news:c59eaf10-c092-4cde-8f5d-2e7a483ad8e5@discussions.microsoft.com...

> Is there any way to find all stored procedures that use linked servers

> or a specific linked server?

>

MVPUser at 2007-9-8 >

SQL Server Hot Topic