When completing an installation I saw the following error – which stopped the installation .
The error occurred during the creation of Indexed View
[2011-10-24 18:21:34.193 02944 error 'App'] A database error occurred: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods." is returned when executing SQL statement "
Options to fix
1) ALTER DATABASE db SET ARITHABORT ON
2) Issue SET ARITHABORT ON from the client when you connect.
Author: Jack Vamvas (http://www.sqlserver-dba.com)
