1. 

   ajdjackson, Member

   Hi

   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).

   Any thoughts?

   Thanks

   Jake
2. 

   myDBR Team, Key Master

   See this forum topic.

   --
   myDBR Team

Reply

You must log in to post.