DF060: A deprecated SET option is being used: CONCAT_NULL_YIELDS_NULL, ANSI_NULLS, ANSI_PADDING, REMOTE_PROC_TRANSACTIONS, or OFFSETS.
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
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?