use sp_dboption to turn on ansi_nulls for DB

[Former Member]

Hi,

We are using SQL Server 2012 as back end database, we are getting below alerts in monitoring.

use sp_dboption to turn on ansi_nulls for DBNAME

Please suggest

[patelyogesh]

Hello Bilal,

Please have a look SAP note as below

129630 - Handling of NULL values and the ansi_nulls setting

Regards,

Yogesh

[former_member215345]

In SQL Server Management studio, under your SAP database Properties enable ANSI NULL by setting it to TRUE.