verify that constraints are set on a dw

  • 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 

  • dbcc checkconstratints ??


    * Noel

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply