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