Click or drag to resize

SA0155 : Deprecated setting of database option CONCAT_NULL_YIELDS_NULL to OFF

The topic describes the SA0155 analysis rule.

Message

Deprecated setting of database option CONCAT_NULL_YIELDS_NULL to OFF

Description

The rule checks database for the ANSI_PADDING and CONCAT_NULLS_YIELDS_NULL database options 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 status of this option can be determined by examining the is_concat_null_yields_null_on column in the sys.databases catalog view or the IsNullConcat property of the DATABASEPROPERTYEX function.

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, Deprecated Features

Additional Information
See Also

Other Resources