Other weirdness along these lines: You can't turn off the ANSI Warnings in TempDB using sp_dboption.

"sp_dboption Displays or changes database options. sp_dboption should not be used on either the master...

I have the same problem. I think the problem is associated with the ANSI WARNINGS dboption in the tempdb database rather than the pubs db. However, the sp_dboption BOL says...