I had to recreate a table in SQL Server just because it was created with ANSI_NULLS ON
Here you can check the requirements to create a persisted computed column on SQL Server.
“…the SET options in the following table must be set to the values shown in the Required value column…”
SET options | Required value | Default server value | Default
OLE DB and ODBC value |
Default
DB-Library value |
---|---|---|---|---|
ANSI_NULLS | ON | OFF | ON | OFF |
ANSI_PADDING | ON | ON | ON | OFF |
ANSI_WARNINGS* | ON | OFF | ON | OFF |
ARITHABORT | ON | ON | OFF | OFF |
CONCAT_NULL_YIELDS_NULL | ON | OFF | ON | OFF |
NUMERIC_ROUNDABORT | OFF | OFF | OFF | OFF |
QUOTED_IDENTIFIER | ON | OFF | ON | OFF |