To disable one certain option of a foreign key in multiple foreign keys in one go.
Posted on 2006-04-26
Sql Server 2000
The following code will give me all foreign key relationship names where I have set the option "enforce relationship for replication"
SELECT OBJECT_NAME(constid) AS [Relationship Name],
OBJECT_NAME(rkeyid) AS [Primary Key Table],
OBJECT_NAME(fkeyid) AS [Foreign Key Table]
FROM sysreferences WITH (NOLOCK)
WHERE OBJECTPROPERTY(constid, 'CnstIsNotRepl') = 0
Now, my taks is to go to those relationship area one by one via enterprise manager and unset/untick the option "enforce relationship for replication".
Can a command line / query be generated to make my task a lot lot easier.