CREATE PROCEDURE [dbo].[sp_TestLink]
--测试链接服务器是否正常 1正常 0异常
@servername varchar(50)--链接服务器名称
AS
BEGIN
SET NOCOUNT ON;
DECLARE @retval int = 0,
@sysservername sysname;
BEGIN TRY
SELECT @sysservername = CONVERT(sysname, @servername);
EXEC @retval = sys.sp_testlinkedserver @sysservername;
SELECT 1;
END TRY
BEGIN CATCH
SELECT 0;
END CATCH;
END
