I am trying to run an Bcp import routine but get an issue on certain tables that are referenced within an Indexed View. I've tried setting the "ARITHABORT ON" and also enabled "QUOTED_IDENTIFIER" on both the table and database but still no joy. I get the error when running the command both through the command prompt and also through management studio. In both cases I get exactly the same error.
The command I run through command prompt looks as follows
bcp "databasename.[dbo].tablename" in C:\temp\bcp_outputTable.txt -S servername\instancename -T -c
The Output is below:
1000 rows sent to SQL Server. Total sent: 1000
1000 rows sent to SQL Server. Total sent: 2000
SQLState = 37000, NativeError = 1934
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]INSERT failed beca
use the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Veri
fy that SET options are correct for use with indexed views and/or indexes on com
puted columns and/or filtered indexes and/or query notifications and/or XML data
type methods and/or spatial index operations.
BCP copy in failed
Please bear in mind that this exact same command works perfectly for other tables that do not have the Indexed views referencing it. I have also tried the added -q command but then I get authentication issues even when adding proper sql username and pwd details.
Any help would be appreciated.