I'm attempting to create a sql 2000 maintenance plan. It keeps failing on me
with the following error:

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 1/2/2007
Time: 11:03:51 AM
User: N/A
Computer: SHAREPOINT-001
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Sharepoint
Maintenance Plan'' (0x1351B36B334F2147A3F8AFD67C71CCB1) - Status: Failed -
Invoked on: 2007-01-02 11:03:33 - Message: The job failed. The Job was
invoked by User NA\spservice. The last step to run was step 1 (Step 1).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I set it to log the events and I received the following:




(null)
(null)
[7] Database OSISYSTE1_SERV: Check Data and Index Linkage...



(null)
[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'.

(null)
(null)
The following errors were found:



(null)
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.


(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **

I'm not a SQL guy by any means so i'm not sure where to go with this from
here. Any help would be appreciated, thanks.

CK (C*@discussions.microsoft.com) writes:
This may help you: http://support.microsoft.com/kb/902388.

lost sa password due to loss of employee
Backup using the proxy account in SQL2005
BCP genric error
Problem on scripting stored procedures
Telling if SQL2005 is running