SA0209 : SET OFFSETS is deprecated

The topic describes the SA0209 analysis rule.

Message

SET OFFSETS is deprecated

Description

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

How to fix

Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Scope

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

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix
20 minutes per issue.
Categories

Deprecated Features, Bugs

Additional Information
Example Test SQL
SQL
Copy
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

Other Resources

Analysis Rules