Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
solart
Posting Yak Master
148 Posts |
 Posted - 2002-07-31 : 14:02:38
|
| 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' goreconfigue with overridegoi.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 solart |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-31 : 14:10:47
|
Technically the settings would be OR'd together using bitwise operators, but it turns out that that is equivalent to summing them together.BOL must've been clear enough, you figured it out on your own.  |
 |
|
|
|
|
|
How to set server option