I have made a simple SQL query to instert information from table [A] to table , this two tables are Navision tables.
This is the query:
INSERT INTO SELECT * FROM [A]
I execute the query and it works well, the problem is if I put in a table in Navision key any value in field SUMINDEXFIELD, if I add information in this field and I try to call the query from cmd the program fail, this is the error:
Msg 1934, Level 16, State 1, Server ESWS52NBT7JXT\NAVDEMO, Line 1
INSERT failed because the following SET options have incorrect settings: 'QUOTED
_IDENTIFIER'. Verify that SET options are correct for use with indexed views and
/or indexes on computed columns and/or filtered indexes and/or query notificatio
ns and/or XML data type methods and/or spatial index operations.
If I execute the query directy in SQL Manager Server it works well but if I try to do the call for SQL server Agent o in cmd appers this error.
Thanks for your help.