I have a table called AGENCIES that has some Foreign keys. I executed the followoing commnad in SQL Analyzer.
ALTER TABLE AGENCIES WITH CHECK CHECK CONSTRAINT FK_AGENCIES_CONTACTS
In Enterprise Manager, I highlighted AGENCIES table and then choose Design Table, then Properties. In the Properties window I seleted the Relationship tab and selected FK_AGENCIES_CONTACTS from the Selected Relationship dropdown list.
In the Properties window "Check Existing Data On Creation" is unckecked. Why? I thought WITH CHECK option would turn on this check box.