I had to use this:

SET ANSI_WARNINGS { ON | OFF }

to get my updates to work. This was actually a much bigger problem since I couldn't run SSIS to do...