SA0162 : Column created with option ANSI_PADDING set to OFF

Column created with option ANSI_PADDING set to OFF

The rule checks tables, views and table-valued functions for columns of type varchar,binary,varbinary or char, which are created with ANSI_PADDING option set to OFF.

In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error.

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

The setting of SET ANSI_PADDING is set at execute or run time and not at parse time.

To view the current setting for this setting, run the following query.

1DECLARE @ANSI_PADDING VARCHAR(3) = 'OFF';
2IF ( (16 & @@OPTIONS) = 16 ) SET @ANSI_PADDING = 'ON';
3SELECT @ANSI_PADDING AS ANSI_PADDING;

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

The rule has a ContextOnly scope and is applied only on current server and database schema.

Rule has no parameters.

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Design Rules, Bugs

SET ANSI_PADDING (Transact-SQL)

Deprecated Database Engine Features

Discontinued Database Engine Functionality

Other Resources