Find out what is causing the error, then do a dbcc checktable, odds are an index is out of whack, rebuild indexes on that table.