DF060: A deprecated SET option is being used: CONCAT_NULL_YIELDS_NULL, ANSI_NULLS, ANSI_PADDING, REMOTE_PROC_TRANSACTIONS, or OFFSETS.

Last modified: December 25, 2024

The topic describes the DF060 T-SQL code analysis rule.

Category

Deprecated

Message

A deprecated SET option is being used: CONCAT_NULL_YIELDS_NULL, ANSI_NULLS, ANSI_PADDING, REMOTE_PROC_TRANSACTIONS, or OFFSETS.

Description

Setting ANSI_NULLS OFF or ANSI_PADDING OFF is not recommended, as it is not supported for certain indexes such as indexed views and indexes on computed columns. Setting CONCAT_NULL_YIELDS_NULL OFF can lead to unexpected results in expressions that rely on this behavior. It is advisable to avoid using REMOTE_PROC_TRANSACTIONS, as remote stored procedures are deprecated. And the OFFSETS option will soon become unavailable.

Noncompliant code example

SET CONCAT_NULL_YIELDS_NULL ON;
GO
 
SET ANSI_NULLS ON;
GO
 
SET ANSI_PADDING ON;
GO
 
SET REMOTE_PROC_TRANSACTIONS ON;
GO
 
SET OFFSETS SELECT ON;
GO