SQL server 跨服务器建视图问题
USE [syn_WIND]
go
CREATE VIEW HS1HC1201WINDDATA_VIEW AS
SELECT [Chrono],[Name],[Value],[Quality],[AlarmLevel] ,[AssocLabel],[BinAttr],[Description],[Domain],[Nature],[SecurityLevel],[Threshold],[VarType]
FROM ywserver3.syn_wind.dbo.HS1HC1201WINDDATA
where 192=Quality
UNION
SELECT [Chrono],[Name],[Value],[Quality],[AlarmLevel] ,[AssocLabel],[BinAttr],[Description],[Domain],[Nature],[SecurityLevel],[Threshold],[VarType]
FROM ywserver4.syn_wind.dbo.HS1HC1201WINDDATA
where 192=Quality
其中 ywserver3为本地服务器, ywserver4为远程服务器,如果 ywserver4关机整个视图就不能查询了,请各位高手指点怎么处理,谢谢了