[dba-SQLServer] SQL Server - sysstat & 0xf = 4

paul.hartland at fsmail.net paul.hartland at fsmail.net
Tue Jun 19 03:34:09 CDT 2007


To all,

Can anyone tell me exactly why this sysstat & 0xf = 4 is used and what exactly it means etc, I know that sysstat is a field in the sysobjects table but the & 0xf = 4 is the bit thats confusing me.  Please ignore my ignorance if this is simple as we are working on a new technology for our stocktaking along with another company, and they have used this is some code to create an SP on the fly:

IF EXISTS (select * from sysobjects where id = object_id('dbo.mySP') and sysstat & 0xf = 4)
 drop procedure dbo.mySP

Thank you for any help on this in advance....


Paul Hartland
paul.hartland at fsmail.net
07730 523179


More information about the dba-SQLServer mailing list