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 |
