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

Script to Change FK Property NotForReplication across many..

 
   Database Help (Home) -> MSEQ RSS
Next:  Setting Boolean Var in Execute SQL task  
Author Message
stardv

External


Since: Apr 21, 2008
Posts: 4



(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:   
Related Topics:
index on a view - Hello, I have a table (TAB) and A View with alias (VIEW) Table cod varchar 3 descr carchar 60 my view cod alias COd1 descr alias DES Now i need a index on view with key COD1 I can't create it. Can..

Creating an alias - I have an alias that can get very long because it maintains a information of where it came from. Is there a way to alias an alias? My first thought was: Declare @T1 varchar(128) Set T1 = 'MyAlias' .... Inner Join Table1 as @T1 This of course does no...

Formatting numeric fields in select-clause - This is propably a very simple question, but I can´t seem to find the answer to it in the documentation. I want to format a numeric field so the result is right justified and zero-filled. ex select 1 will give the result 01 How do I manage this..

Simple Query problem - Sample table as follows Order ID Stock Code Status --------- ------- ------- 203 STK1 3 203 STK2 2 203 STK4 3 204 STK1 3 204 STK5 3 205 ..

query assistance -return most recent date - I have a table that has two fields, pkg_num, which is a number, and del_date_time, which is a date-time. The table can contain duplicate pkg_num values, as long as the del_date_time values are different for any given number. I need a query that will...
   Database Help (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 ]