FastEddie___
asked on
Disable Foriegn Key Relationships for Replication
Is there a SQL Server 2000 script that will automatically uncheck the "Enforce relationship for replication" checkbox?
I am trying to replicate data accross SQL servers and need to disable foriegn key relationships.
I don't want to have to go to each table and do it manually from:
Table Properties - Relationships - Enforce relationship for replication (checkbox).
Any help would be greatly appreciated.
-Eddie
I am trying to replicate data accross SQL servers and need to disable foriegn key relationships.
I don't want to have to go to each table and do it manually from:
Table Properties - Relationships - Enforce relationship for replication (checkbox).
Any help would be greatly appreciated.
-Eddie
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I appreciate your help though.
-Eddie