SA0162 : Column created with option ANSI_PADDING set to OFF
The topic describes the SA0162 analysis rule.
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;
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.
© Ubitsoft Ltd. All Rights Reserved.