Click or drag to resize

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.

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.

Categories

New Rules, Deprecated Features

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

Analysis Results

 MessageLineColumn
1SA0210 : Setting FMTONLY option is deprecated.14
2SA0210 : Setting FMTONLY option is deprecated.24
See Also

Other Resources