One of the configuration options that can be set for the server is called "user options". User options contains sub-options such as ansi_warnings, ansi_padding, ansi_nulls, arithabort, etc..

Using T-SQL, how are these set?

sp_configure 'user options', @configvalue = 'value'
go
reconfigue with override
go

i.e. Are the individual option values summed. Say I wanted to set ansi_warnings (whose value is 8) and ansi_nulls (whose value is 32) on and all other user options off. Then is my @configvalue 40?

Sorry, but I don't feel BOL is clear on how to set these options.

TIA Gary