SQL Query fails to update

Question

HI

I am trying to update a row on an SQL SERVER 2005. When I run the SQL, i recieve a message indicating that the Execution was successful and 1 row was effected. However, when I do a select against this row I supposedly updated, the value remains unchaged. What's going on with this SQL server when a successful query does absolutely nothing.

The query is:

UPDATE [database1].[dbo].[table1] 
   SET [order] = 215 
WHERE [email] = '[email protected]'

Answer 1

Thanks KM I checked the triggers and you were right. There was a trigger that I had to disable to get the sql to work.

Answer 2

check for a trigger on [database1].[dbo].[table1], possibly it is doing something you are not aware of.

EDIT

without seeing the trigger code, you probably just need to add support for [order] into the trigger, since it is a new column (based on your comment).