SA0210 : Setting FMTONLY option is deprecated

The topic describes the SA0210 analysis rule.

Message

Setting FMTONLY option is deprecated

Description

The rule checks T-SQL code for setting FMTONLY option.

How to fix

Do not use this feature. This feature has been replaced by sp_describe_first_result_set, sp_describe_undeclared_parameters, sys.dm_exec_describe_first_result_set, and sys.dm_exec_describe_first_result_set_for_object.

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
1 hour per issue.
Categories

Deprecated Features, Bugs

Additional Information
Example Test SQL
SQL
1SET FMTONLY ON
2SET FMTONLY OFF

Analysis Results
  Message Line Column
1 SA0210 : Setting FMTONLY option is deprecated. 1 4
2 SA0210 : Setting FMTONLY option is deprecated. 2 4
See Also

Other Resources