@@Options - by John.Morehouse

Status : 


Sign in
to vote
ID 3106386 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 10/10/2016 5:42:42 PM
Access Restriction Public


In the documentation for @@Options in Books Online, it states that "The result is 1010101111000. The left most characters (binary 1, 2, and 4) are 0, indicating that IMPLICIT_TRANSACTIONS and CURSOR_CLOSE_ON_COMMIT are off. The next item (ANSI_WARNINGS in the 1000 position) is on. Continue working right though the bit map, and down in the list of options. When the right-most options are 0, they are truncated by the type conversion. The bit map 1010101111000 is actually 001010101111000 to represent all 15 options.".    

I believe that the directional verbiage is backwards and that it should read that the right most characters (binary 1,2,4) are 0 and that the when the left most characters are zero that they get truncated off by the type conversion.  
Sign in to post a comment.
Posted by Microsoft on 10/11/2016 at 10:31 AM
Wow. This must have been wrong for years! Thank you for reporting this. I have fixed it. Rick Byham.