Click or drag to resize

SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated

The topic describes the SA0211 analysis rule.

Message

Setting REMOTE_PROC_TRANSACTIONS option is deprecated

Description

The rule checks T-SQL code for statements setting REMOTE_PROC_TRANSACTIONS option.

This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. This option is provided for backward compatibility for applications that use remote stored procedures. Instead of issuing remote stored procedure calls, use distributed queries that reference linked servers. These are defined by using sp_addlinkedserver.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

New Rules, Deprecated Features

Additional Information
Example Test Script
SQL
1SET REMOTE_PROC_TRANSACTIONS ON
2SET REMOTE_PROC_TRANSACTIONS OFF

Analysis Results

 MessageLineColumn
1SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated.14
2SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated.24
See Also

Other Resources