首页 > 数据库技术 > 详细

SQL 系统表应用

时间:2018-05-21 19:12:59      阅读:255      评论:0      收藏:0      [点我收藏+]

查看link server 

select DD.System,DD.DB,DD.previous_processing_dte, DD.processing_dte,LS.LinkServerName,LS.DBServer,ServerList.ServerName from DD
INNER JOIN
(
 SELECT a.name as LinkServerName,data_source as DBServer
 FROM sys.Servers a
 LEFT OUTER JOIN sys.linked_logins b ON b.server_id = a.server_id
 LEFT OUTER JOIN sys.server_principals c ON c.principal_id = b.local_principal_id
) LS
on DD.LinkServerName = LS.LinkServerName
LEFT JOIN
(
 select ServerName,HostName + ‘,‘ + SQLPort as DBServer from conf.DBServerList
 union
 select ServerName,‘.,1443from conf.DBServerList
 where HostName = @@SERVERNAME
) ServerList
on LS.DBServer = ServerList.DBServer

SQL 系统表应用

原文:https://www.cnblogs.com/hellohongfu/p/9068612.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!