verify that constraints are set on a dw

• Kevin Muller

  SSC Enthusiast

  Points: 155

  More actions

  July 16, 2007 at 11:46 am

  #117379

  I want to verify that the constrints exist on my datawarehouse before I start my load process so that I don't have any failures in that area.

  Is there a way to check for a certain condition such as:

  select *

  from sysobjects

  where name like 'FK%'

  If the results are below a certain number, then send out an alert??

  Thanks

  -k 

• noeld

  SSC Guru

  Points: 96590

  More actions

  July 16, 2007 at 1:21 pm

  #719776

  dbcc checkconstratints ??

  
  * Noel