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. 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.
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.
New Rules, Deprecated Features
1SET REMOTE_PROC_TRANSACTIONS ON 2SET REMOTE_PROC_TRANSACTIONS OFF
|1||SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated.||1||4|
|2||SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated.||2||4|
© Ubitsoft Ltd. All Rights Reserved.