I am trying to change setting ”NotForreplication” across all FKs. However
so far the only option is to drop each FK by name and recreate it. I was
looking to create a script that goes through all FK and does the change. I
am running SQL 2000, however in SQL 2005 I found table sys.foreign_keys
That has notforrepl column where I can just reset the bit, but in SQL 2000
sys foreignkey has no column indicating FK’s propertys) Any suggestion how I
can approach. Also I have all my tables replicated and I changed all FK
manually on the server but I could not change it though replication without
reinitialize subscriptions, any ideas?
Thank you
--
Treat everyone like you want to be treated !!!
Stardv
>> Stay informed about: Script to Change FK Property NotForReplication across many..