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