SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated |
 |
The topic describes the SA0211 analysis rule.
MessageSetting REMOTE_PROC_TRANSACTIONS option is deprecated
DescriptionThe 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.
How to fixDo not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
ScopeThe rule has a Batch scope and is applied only on the SQL script.
ParametersRule has no parameters.
RemarksThe rule does not need Analysis Context or SQL Connection.
Effort To FixCategoriesDeprecated Features, Bugs
Additional InformationExample Test SQL|
SQL
1SET REMOTE_PROC_TRANSACTIONS ON 2SET REMOTE_PROC_TRANSACTIONS OFF |
Analysis Results| 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 |
See Also