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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-15 : 08:44:17
|
| john writes "Hello,I am getting an error when using the Database Maintenance Plane and selecting 'organize data and index pages' option.I think the problem is related to one table that has a calculated field.I have a column that gets it value from the formula:([LISTING_LASTNAME] + ' ' + [FIRSTNAME])The above are two columns that I add together.-------------This is the error-----------------[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'.---------------end-----------------Does anyone have any thoughts as to why I am getting this error?I have also tried to set the following option ON and OFF with no success.--SET TO ON--ANSI_NULLS ANSI_PADDINGANSI_WARNINGSARITHABORTCONCAT_NULL_YEILDS_NULLQUOTED_IDENTIFIERS--SET TO OFF--NUMERIC_ROUNDABORT Thanks." |
|
|
|
|
|
calculated field