SYSOBJECTS system table -- STATUS column = 32???

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  February 12, 2004 at 1:56 pm

  #107267

  Hi,

  Sql Server 2000 ...

  In the sysobjects systable for a user database, does anybody know what the value 32 represents in the status column for where xtype = 'PK'?? I have 5 entries set to the value 32. THe others are set to the value 16?? The ones with 32 do not script???

  Thanks. Jeff

  Many thanks. Jeff

• wz700

  SSCertifiable

  Points: 7133

  More actions

  February 12, 2004 at 9:20 pm

  #493933

  It may stand on nonclustered primary key.