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