(And yes, I know I spelled DR0P TABLE with a zero instead of an "O". In posting on this forum, I have discovered the my employer seems to have some kind of security filter that blocks outgoing web traffic that includes certain SQL statements. If I spelled DR0P TABLE correctly, that filter would catch this post and return a message that my machine is unable to communicate with the server.)
*lol* This sounds like someone read the famous "Bobby Tables" cartoon[/url] - and then completely misunderstood it! *lol*
"Little Bobby Tables" is very well known around here, so I don't think that's the problem. Plus, the filter catches outgoing content. The filter only seems to catch certain T-SQL statements, though. I'll have to ask the sysops or infosec guys about this next time I'm in their end of the building.
It clearly says "any non-zero value will be converted to 1". I could not find the concept of the number being converted into binary and than getting truncated. Can anyone pour some light on what is happening internally?
Jason...AKA CirqueDeSQLeil _______________________________________________ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR Posting Performance Based Questions - Gail Shaw[/url] Learn Extended Events