查看链接服务器依赖项 sql server 2008

2022-01-15 00:00:00 dependencies sql-server linked-server

有谁知道如何/是否可以查看依赖于 Sql Server 2008 中链接服务器的所有表/视图/存储过程.基本上就好像链接服务器可以访问上下文菜单查看依赖项"?

Does any know how / if it is possible to view all tables/views/stored procedures that depend on a linked server in Sql Server 2008. Basically as if the context menu "View dependencies" was accessible for linked servers?

非常感谢任何帮助.

谢谢

推荐答案

搜索一下

SELECT OBJECT_NAME(object_id), *
FROM sys.sql_modules
WHERE definition LIKE '%myLinkedServer%'

或使用免费 红门SQL 搜索 对 GUI 做同样的事情

Or use the free Red gate SQL Search to do the same with a GUI

没有跟踪服务器级链接服务器对象和数据库级对象之间依赖关系的表或功能

There is no table or feature that tracks dependencies between the server-level linked server objects and database-level objects

注意:INFORMATION_SCHEMA 视图和旧版系统注释会截断定义，因此对于定义搜索不可靠.

Note: INFORMATION_SCHEMA views and the legacy syscomments truncate the definition so are unreliable for definition searches.

相关文章