-
How to set server option using T-Sql ("user options")
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|