-MAX PLUS = 12 If you try making More Than 12 = Back To 12 -- if (@eventID = 9 or @eventID = 11 or @eventID = 6) begin update SRO_VT_SHARD.dbo._Items set SRO_VT_SHARD.dbo._Items.OptLevel = 12 where SRO_VT_SHARD.dbo._Items.optLevel >= 12 END Add To LogChar ShardLog