I was supplied a script to run that contains the following:
if exists (select * from sysobjects where id = object_id('dbo.mytbl') and sysstat & 0xf = 3)
drop table dbo.mytbl
In BOL, there's no real explanation of sysstat other than "Reserved for SQL Server internal use only. Future compatibility is not guaranteed."
When I googled it, I see quite a bit of sysstat & 0xf = 4 (not 3).
What is this? Is it really necessary to use it the way it is used above?