In enterprise manager, you can go into the table properties, find the
constraint in the dropdown box and uncheck 'ENABLE CONSTRAINT FOR
REPLICATION'. That works in SQL 7, I don't know about 2000
-----Original Message-----
From: stas [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2001 16:00
To: CF-Talk
Subject: Temporarily disabling DB constraints
Hello,
I'm using MS SQL2000 and need to replicate data from one box to another. The
process is failing because of certain constraints. Is there a non-hack
workaround to this issue?
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
