I wanted to update a tinyint column of a table that contains nothing but
NULL values. I issued this statement:
SET Sub_Address_Status = 0
WHERE Sub_Address_Status IS NULL
In response i got:
Server: Msg 512, Level 16, State 1, Line 0
Subquery returned more than 1 value. This is illegal when the subquery
follows =, !=, <, <= , >, >=, or when the subquery is used as an expression.
Command has been aborted.
Nothing was updated... I can sucessfully update a single record in that
This message cannot come from this statement on it's own (unless you have managed to hit a bug in sql server somehow - this isn't involved in replication is it?).
Do you have a trigger on the table?
Otherwise are you executing something else at the same time?