使用SSMS 2008客戶端工具逆向生成了創建鏈接服務器的腳本時，在測試環境執行是報如下錯誤：'(null)' is an invalid product name.

USE [master]

GO

IFEXISTS (SELECT srv.NAME 

 FROM sys.servers srv 

 WHERE srv.server_id != 0 

 AND srv.NAME = N'MES_DB_LINK_TEST') 

 EXEC master.dbo.Sp_dropserver 

 @server=N'MES_DB_LINK_TEST', 

 @droplogins='droplogins'

go

EXEC master.dbo.Sp_addlinkedserver 

 @server = N'MES_DB_LINK_TEST', 

 @provider=N'SQLNCLI', 

 @datasrc=N'192.168.xxx.xxx', 

 @catalog=N'TEST'