Click or drag to resize

SA0162 : Column created with option ANSI_PADDING set to OFF

The topic describes the SA0162 analysis rule.

Message

Column created with option ANSI_PADDING set to OFF

Description

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;

Scope

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

Parameters

Rule has no parameters.

Remarks

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

Categories

Design Rules

Additional Information
See Also

Other Resources