InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 05:27:28 GMT20http://www.sqlservercentral.com/Forums/Topic1409337-1549-1.aspxLog-shipping will work fine after the change. But have you checked the application connecting the database. Compatibility 80 means SQL 2000 and 90 means sql 2005. RegardsDhananjayTue, 22 Jan 2013 03:44:39 GMTDhananjay-440114http://www.sqlservercentral.com/Forums/Topic1409337-1549-1.aspxI have tried its working fine.Sun, 20 Jan 2013 20:46:16 GMTmahesh.dasonihttp://www.sqlservercentral.com/Forums/Topic1409337-1549-1.aspxIs 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 levelSun, 20 Jan 2013 19:51:06 GMTmahesh.dasoni