Finding Stored Procedures that use linked servers

Hot Topic

Complicated Query with Subs for Grand Total
How to mimic replmerg.exe in vb.net
How can I get Transactional Republishing to work?
The e-mail address or SMTP server value is not valid.
Trigger BEFORE ?
Join the SQL Server 2005 SP1 Webchat March 22nd 9:00 am PST
Conditional Split problem
Need Bulk Insert help
Using User-defined functions in SQL Server Management Studio Expressl
Trouble with Iif!

SQL Server

Working Samples required Import Column Transformation
“AcquireConnection method call to the OLEDB Connection Manager for SQL Server failed” Error
SQL 2005 CTP up to RTM
Management Studio Express CTP update now available
creating a database
Maximum Conversation timer interval
exposing proprietary data to SSIS (Newbie alert)
Error on Attaching Database
Copy Database error on Execute SQL Server Agent Job
Transport Failed to Connect to the Server

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


Answer this question

Finding Stored Procedures that use linked servers

  • Yonathan Masovich

    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 > >
  • Finding Stored Procedures that use linked servers
Answer this question