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 |
|
richxyz
Starting Member
12 Posts |
 Posted - 2007-10-01 : 09:13:45
|
| I have a 10GB database and am trying to run a database maintenance plan for the first time and it fails with the error below (from the error log). This db maintenance plan is set to update statisics with 10% of database to sample.What do I need to do to correct the setting 'QUOTED_IDENTIFIER, ARITHABORT'?Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'XXXX' as 'NT AUTHORITY\SYSTEM' (trusted)Starting maintenance plan 'DB Maintenance Plan XT-Checkdb' on 9/30/2007 3:00:01 AM[1] Database xt: Updating Query Processor Statistics (sampling 10 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, ARITHABORT'. ** Execution Time: 0 hrs, 0 mins, 1 secs **End of maintenance plan 'DB Maintenance Plan XT-Checkdb' on 9/30/2007 3:07:18 AMSQLMAINT.EXE Process Exit Code: 1 (Failed) |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 11:26:58
|
I hate the side-effects of using computed columns  |
 |
|
|
richxyz
Starting Member
12 Posts |
Posted - 2007-10-01 : 12:00:58
|
| hi Kristen, are you saying this is caused by a computer column in the database? I looked for one and cannot find it. The following query returns zero rows: select * from syscolumns where iscomputed = 1 and type = 106 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 12:07:58
|
| Well that's one case, but might be some flavours of VIEW too, I've forgotten which. INDEXED VIEWs perhaps?Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-01 : 22:50:54
|
| It's maintenance plan issue as I know, write script to update statistics. |
|
|
|
|
|
|
Update Statistics fails