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 |
|
Angelindiego
Starting Member
3 Posts |
 Posted - 2005-08-24 : 17:23:24
|
This error in conjunction with error 22029 is concerning the optimizations job on one of my databases. It says:[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, ARITHABORT'.and it has to do with indexes on a computed column. OK, my issue here is that the table that I have in that db that has a computed column is NOT indexed!! Now what do I do??I have read that I need to make a job step and preceed the exec sql_maint step with it, setting arithabort and Quoted_Identifer to on and update statistics. I am not sure of the syntax, because when I tried that, it told me that the "flow" was wrong....Any ideas???? Thanks a ton in advance!!  |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Angelindiego
Starting Member
3 Posts |
Posted - 2005-08-29 : 17:00:48
|
| Referring me to Tara's blog was fabulous!! There is alot of fun stuff there!!! Thank you!OK, I get another opt job failure this morning, this time on the system db's job. The other error (originally 22029 in conjunction with 1934) was stated to be with indexing on computed columns. Now this system one?? WUSSUP??? I will go do some more research on her blog page!! Thanks eyechart!! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 17:03:33
|
| Could you post the exact error?I saw your e-mail, however we can have the discussion here in the forums.Tara |
|
|
|
|
|
|
Error 1934