SQLTeam.com | Weblogs | Forums

Sql update is being ignored

this is a very strange issue
I run in sql managment studio

update stock set marketplaceclearance=null where id=41277

this returns
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(1 row affected)

I then do
select marketplaceclearance,* from stock where id=41277
and it still shows the value that was there before
it is not updating but not giving an error
please advise

nevermind - I figured out the issue - there was a trigger changing the value