Check if Constraint is enabled or disable

• roberto armellin

  SSC Enthusiast

  Points: 146

  More actions

  November 3, 2011 at 1:03 am

  #250236

  Comments posted to this topic are about the item Check if Constraint is enabled or disable

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  November 3, 2011 at 1:21 am

  #1402507

  I think script is missing. Can you please check?

  Thanks

• roberto armellin

  SSC Enthusiast

  Points: 146

  More actions

  November 3, 2011 at 1:53 am

  #1402513

  excuse me but this is my first post. I edited the script and now I wait for the publication of this issue.

  This is the script :

  select

  [Table] = o2.name,

  [Constraint] = o.name,

  [Enabled] = case when ((C.Status & 0x4000)) = 0 then 1 else 0 end

  from sys.sysconstraints C

  inner join sys.sysobjects o on o.id = c.constid -- and o.xtype='F'

  inner join sys.sysobjects o2 on o2.id = o.parent_obj

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  November 3, 2011 at 3:35 am

  #1402543

  roberto armellin (11/3/2011)

  ---

  excuse me but this is my first post. I edited the script and now I wait for the publication of this issue.

  This is the script :

  select

  [Table] = o2.name,

  [Constraint] = o.name,

  [Enabled] = case when ((C.Status & 0x4000)) = 0 then 1 else 0 end

  from sys.sysconstraints C

  inner join sys.sysobjects o on o.id = c.constid -- and o.xtype='F'

  inner join sys.sysobjects o2 on o2.id = o.parent_obj

  No issues. Thanks for sharing.

  Thanks

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 12, 2016 at 6:31 am

  #1878512

  Thanks for the script.