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

Robin robin at musicalmemories.co.uk
Tue Jun 19 04:03:31 CDT 2007


Hi Paul,
It's a way of checking if a table exists..

See here
http://www.dotnet247.com/247reference/msgs/21/107015.aspx

Rgds
Robin

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: 19 June 2007 09:34
To: accessd; dba-sqlserver
Subject: [dba-SQLServer] SQL Server - sysstat & 0xf = 4
Importance: High


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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list