如下面的代码:
-- 添加链接服务器
EXEC sp_addlinkedserver 'srv_lnk','','SQLOLEDB','.'
EXEC sp_serveroption 'srv_lnk','rpc out','true'
GO
-- 测试语句
--SET NOCOUNT ON
BEGIN TRY
DECLARE
@error_number int,
@error_message nvarchar(2048)
EXEC(N'
SET NOCOUNT ON
USE tempdb
BEGIN TRY
DELETE FROM [NEWID()]
END TRY
BEGIN CATCH
SELECT
? = ERROR_NUMBER(),
? = ERROR_MESSAGE()
END CATCH
',
@error_number OUTPUT,
@error_message OUTPUT
)AT srv_lnk
END TRY
BEGIN CATCH
SELECT
2,
ERROR_NUMBER(),
ERROR_MESSAGE()
END CATCH
GO
-- 删除链接服务器
EXEC sp_dropserver 'srv_lnk', 'droplogins'
