SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated |
![]() |
The topic describes the SA0211 analysis rule.

Setting REMOTE_PROC_TRANSACTIONS option is deprecated

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. 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.

Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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

Rule has no parameters.

The rule does not need Analysis Context or SQL Connection.


Deprecated Features, Bugs


SQL
1SET REMOTE_PROC_TRANSACTIONS ON 2SET REMOTE_PROC_TRANSACTIONS OFF |

Message | Line | Column | |
---|---|---|---|
1 | SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated. | 1 | 4 |
2 | SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated. | 2 | 4 |
