Transact SQL Question

[Brent Helms]

I am having a tough time finding out how to manually write out the TSQL to generate a junction table that contains the following integrity constraint: "Check Existing Data On Connection". 

This is what I have so far:

CREATE TABLE sec_ApplicationModuleAccess
(
 ApplicationID INT NOT NULL,
 ApplicationModuleID INT NOT NULL
 CONSTRAINT sec_ApplicationModuleAccess_fk FOREIGN KEY (ApplicationID)
 REFERENCES sec_Applications (ApplicationID),
 CONSTRAINT sec_ApplicationModuleAccess_fk2 FOREIGN KEY (ApplicationModuleID)
 REFERENCES sec_ApplicationModules (ApplicationModuleID),
 CONSTRAINT sec_ApplicationModuleAccess_pk PRIMARY KEY CLUSTERED(ApplicationID,ApplicationModuleID)
)

The problem is: It does not set "Check Existing Data On Connection" to true (or checked).  It does set "enforce relationship for replication, inserts, and updates to true. 

Any ideas what the missing link is?

Regards,

Brent Helms
Carlot.com