I run an update on the SQL table using below code, it updates the table correctly. But after 5-7 minutes the data rolls back. Why does this happen? I don’t see any logs or errors in the SQL Server Logs. Any recommendations?

update APP_RecipeIngredients
set Ingredient = ‘DIM’, IngredientDesc = ‘DIMODAN ML90’
where BOMCode in (‘088100′,’088088’)
and Revision in (2,3)
and Deleted = ‘N’
and Ingredient = ‘088471’

The data updates with the new ingredient DIM but it rolls back to 088471 again after few minutes.