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
|1||SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated.||1||4|
|2||SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated.||2||4|