Is it fine if we change compatibility level of a Database which is in Logshipping from 80 to 90 in Sql server 2005 as i am getting below error while index rebuilding.
"ALTER 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.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The Database is in Sql server 2005 but its compatibilty is 80 instead of 90.
Will it affect the logshipping if we change the compatibilty level