Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
schinni
Yak Posting Veteran
66 Posts |
 Posted - 2003-03-07 : 20:24:55
|
| Hello!I am executing this as a job on Sql Server 2000,win2k EXECUTE master.dbo.xp_sqlmaint N'-D "db name" -Rpt "H:\mssql\BackupLog\db name_DB_Report.txt" -DelTxtRpt 4WEEKS -WriteHistory -VrfyBackup -BkUpOnlyIfClean -UpdOptiStats 100 -CkDB -BkUpMedia DISK -BkUpDB "H:\Mssql\Backup" -DelBkUps 1WEEKS -BkExt "BAK"'i get the below errorMicrosoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'XXX' as 'XXX/XXXXX' (trusted)Starting maintenance of database 'MediaBin Repository' on 1/18/2003 10:00:01 PM[1] Database MediaBin Repository: Updating Query Processor Statistics (sampling 100 percent of the data)...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. ** Execution Time: 0 hrs, 0 mins, 1 secs **End of maintenance for database 'Db name' on xxxxxxxxxxxxxSQLMAINT.EXE Process Exit Code: 1 (Failed)I am executing the same job but different database that works fine,everything is samei checked sp_dboption for quoted identifier on both databases ,it is offcan any body help me!Thanks in Advance |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-03-07 : 21:42:31
|
| [url]http://groups.google.com/groups?q=(ODBC+SQLState:+42000)+and+MGK&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=1802e01c229c0%248567b0a0%249be62ecf%40tkmsftngxa03&rnum=1[/url]Edited by - ValterBorges on 03/07/2003 21:44:53 |
 |
|
|
|
|
|
Error while executing jobs using sqlmaint utility