Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Script to Change FK Property NotForReplication across many..

 
   Database Forums (Home) -> MSEQ RSS
Next:  work with xml file  
Author Message
stardv

External


Since: Jul 29, 2008
Posts: 1



(Msg. 1) Posted: Tue Jul 29, 2008 3:18 pm
Post subject: Script to Change FK Property NotForReplication across many Foreign
Archived from groups: microsoft>public>sqlserver>mseq (more info?)

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.. 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> MSEQ All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]