"enforce relationships for inserts and deletes" is an Access option, is it?
There is no such thing in SQL Server, foreign keys are always on. WITH
NOCHECK only doesn't check the Foreign key when it is created, but
afterwards it is always applied. It is not a recommended option, because
later rows that violate the foreign key might cause problems.
If you want "enforcing relationships for tion" off, you can specify
NOT FOR TION.
Jacco Schalkwijk MCDBA, MCSD, MCSE
"Ben" <nu> wrote in message