Mateen
asked on
To disable one certain option of a foreign key in multiple foreign keys in one go.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
There are may be more than one thousand foreign keys across multiple database.
Simply the previous user / me have the habit to set the replication enforcement option.
While I receive any dynamic sql, I have already started doing it manually.