I can use the following query in SSMS fine:
use Database
Update Table
SET LRDT ='12/03/2035 14:00:00'
I need to automate this; either in a *.vbs or a *.sql which get's called via SQLCMD. SQLCMD errors if I try and run this saying the syntax for the SET is incorrect:
Msg 1934, Level 16, State 1, Server XXXXXXXX, Line 2
UPDATE 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.