SA0209 : SET OFFSETS is deprecated |
 |
The topic describes the SA0209 analysis rule.
MessageSET OFFSETS is deprecated
DescriptionThe rule checks T-SQL code for setting OFFSETS option.
This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
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.
CategoriesDeprecated Features, Bugs
Additional InformationExample Test ScriptSQL
1SET OFFSETS SELECT, FROM, ORDER, TABLE, PROCEDURE, STATEMENT, PARAM, EXECUTE ON
Analysis Results
| Message | Line | Column | |
|---|---|---|---|
| 1 | SA0209 : SET OFFSETS is deprecated. | 1 | 4 |
See Also