status2 value 'not in the book'

my database shows a status2 value of 1090519040. But in http://msdn.microsoft.com/en-us/library/aa260406%28SQL.80%29.aspx i do not see such a value- how do you interpret it then?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
anushahannaAuthor Commented:
still do not see 1090519040 in that page? would you expect me to see it?
0
chapmandewCommented:
Case status2 & 1090519040 when 1090519040 then 1 else 0 end.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Scott PletcherSenior DBACommented:
>> still do not see 1090519040 in that page? would you expect me to see it? <<

No.  That is the combination of two different bit values being set:

1073741824
16777216

Unfortunately, BOL doesn't document the meanings of those two particular bits.
0
anushahannaAuthor Commented:
>>That is the combination of two different bit values being set

can you pl explain how that works..
0
Scott PletcherSenior DBACommented:
In SQL an integer is signed, and is 4 bytes, thus 31 bits.

Each bit can be on or off, of course, and has its own unique value.  Off is always 0.  On is by power of two, like so:
Bit0 = 1; Bit1 = 2; Bit3 = 4; Bit4 = 8; etc.

So, say bits 1 and 4 were on ... the field would contain 10 ( 2 + 8 ) .

Note that no bits ever overlap, even when added up.  That is, the sum of all preceding bits is always one less than the current bit.  (For example, Bit5 = 16; the sum of all earlier bits being on is 15).

Thus, you can always tell which individual bits are on and which are on in a given total value for the integer.
0
anushahannaAuthor Commented:
very helpful explanation. thanks scott.

in this reference, can you show how does 1073741824 & 16777216 result in 1090519040
0
Scott PletcherSenior DBACommented:
Add them:

1073741824 + 16777216 = 1090519040

That means no other bits are on, or the value would be higher.  Each bit on increases the value of the integer column.

0
anushahannaAuthor Commented:
OK. Many thanks Scott.

But, on the first hand, how did you quickly discern the 2 numbers.
16777216 is also not in that reference.

do you know these numbers just by experience?

and 1073741824 is in status column. So that means these values float between status and status2?
0
Scott PletcherSenior DBACommented:
>> do you know these numbers just by experience? <<

Nah.  I just kept using power of 2 values, then did a quick test to see if they were present :-) .


0
anushahannaAuthor Commented:
that makes a brilliant expert! Thanks Scott! You always have an extra insight into things - simple yet quiet impact-ful.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.