Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Link Server Dependency

Author  Topic 

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2004-10-26 : 16:59:37
How can I find all dependent objects for a Linked server?

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-10-26 : 17:19:34
[code]select object_name(id) from syscomments
where text like('%name_of_linked_server%')[/code]
Is that what you wanted ?

rockmoose
/* Chaos is the nature of things...Order is a lesser state of chaos */
Go to Top of Page

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2004-10-26 : 17:28:13
Looks like that will work.


Go to Top of Page
   

- Advertisement -