I'm trying to import a pipe-delimited file into a SQL Server table that has a calculated column.
I'm getting this error message:
SQLSTATE: 42000, code: 1934
INSERT failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
After some Googling I added the following in the import SP just after the begin and before the insert statement:
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
but this didn't make any difference (I also tried setting the above to OFF).