问导致超时的链接服务器上的事务

EN

INSERT INTO [RemoteServer].[DbName].[SchemaName].[TableName] VALUES (1, 'bar');

BEGIN TRANSACTION
BEGIN TRY
    INSERT INTO [RemoteServer].[DbName].[SchemaName].[TableName] VALUES (1, 'bar');
    COMMIT TRANSACTION
    PRINT 'insert done!';
END TRY
BEGIN CATCH
    PRINT 'insert faild!';
    PRINT 'Error Message: ' + ERROR_MESSAGE();
    ROLLBACK TRANSACTION
END CATCH

OLE DB provider "SQLNCLI11" for linked server "RemoteServer" returned message "No transaction is active.".

(0 row(s) affected)
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.