April 27, 2005 at 9:22 am
Hi ,
i am having replication in dev ,test and production environment,but when i see the schema option in dev/test for an article i find schema option
0x0000000000000031 but in production i find it is
0x00000000000000F3 and believe it should be 0x00000000000000F3 everywhere since i am not using any customize things ,so i need to know is this schema option impact in any way if it is not 0x00000000000000F3 .
Thanks
April 27, 2005 at 10:31 am
sqlquery:
The difference between F3 and 31 is that the 31 is not generating non-clustered indexes nor the declared referential integrity on the primary keys in the schema.
the non-clustered indexes may not be a problem but "I" would check the primary keys and foreign keys on the replicated tables.
hth
* Noel
April 28, 2005 at 5:39 am
thanks,so if i update the column in sysarticle directly from 31 to F3 option ,and give the snapshot again so will it work?
April 28, 2005 at 1:53 pm
looking at the workflow begining at sp_addarticle it seems to be the case that what you are proposing should work but it is definetly a very unconventional method and I would Advice you try it first on NON production.
are you sure is the same article we are talking about here?
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply