Just installed SPS. I run a weekly Database maintenance (Reorganize data and index pages and check DB integrety)on the site database and I get this error message: ************************************************************************** Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'xxxxxx' as 'alxxx\xx906' (trusted) Starting maintenance plan 'Reorganize Index and pages - Integrity check' on 4/27/2005 10:30:02 PM [1] Database xxxxWSS1_SERV: Check Data and Index Linkage... [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'. The following errors were found: [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, 2 secs ** [2] Database xxxxWSS1_SITE: Check Data and Index Linkage... ** Execution Time: 0 hrs, 18 mins, 30 secs ** Deleting old text reports... 0 file(s) deleted. End of maintenance plan 'Reorganize Index and pages - Integrity check' on 4/27/2005 10:48:35 PM SQLMAINT.EXE Process Exit Code: 1 (Failed) ****************************************************************************** anyone can help me on this Regards JP
