--here is the scheduled job

SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 307DD5CB-26E7-4982-A075-C4458825A612 -Rpt "D:\Prod SQL Data\MSSQL$PRODUCTION\LOG\User Tables DB Maintenance Plan0.txt" -DelTxtRpt 1WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '



--here is the output
[4] Database BACKLOGS: Index Rebuild (leaving 10%% free space)...

    Rebuilding indexes for table 'Can_Backlog_Format'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.

    ** Execution Time: 0 hrs, 0 mins, 1 secs **

I've tried everything short of writing the optimization script by hand. all the backups etc work perfectly, just the optimizations blows out.

Any help greatly appreciated!
David

See if this link gives you any help...

http://groups.google.com/groups?hl=e...a03%26rnum%3D1

Sorry, try this

http://groups.google.com/groups?q= ODBC SQLState: 42000 and MGK&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=1802e01c229c0%248567b0a0%249be62ecf%40tkmsf tngxa03&rnum=1