I'm confused by the use of sp_configure and I can't find a clear source anywhere to explain it. If the "user options" is made up of a bitmap of options and position 8 is ansi_warnings, you execute this:

EXEC sp_configure 'user options', 8 ;

GO

RECONFIGURE ;

Does that not zero all the other options within user_options and set the whole bitmap to ...000001000?

If not and it just "additionally" turns ANSI_WARNINGS on presumably with an implicit bitwise "AND" within the proc, how do you turn just ANSI_WARNINGS (or any other single option) off again?

Thanks

Kev