How is scriptoptions defined? That may give you a key, if you can do something 'other' than all - for instance, list each component separately in the central part...

In snapshot replication, no. In Merge replication, depends on how you've set up your articles in the merge, but normally (simple cases) the tables need to match up. ...

without meaning to be insulting, when i saw your last post, my first thought was..... Yoda. Use the force. Why did i react that way? because you...

How many do you have in total? Have you tried to use the GUI for just one, to see what scripts you can extract? It could be that...

I believe that you can leave that configuration alone. As long as you allow for a pull subscription, you can let the subscriber pull the data down to it....

Did you try dropping the Push subscription and using a Pull instead? Is that feasible?

Do you have any system generated ID fields in the tables? IF so, did you mark them 'not for replication' or set up different ranges for each of the...

noeld (8/21/2008)

---

Sorry for the bad news but from what I have seen in republishing architectures the solution is "peer-to-peer". Merge was advertised as the tool of choice once but DDL...

If it's not custom code, having vendors implement such a change for their 'COTS' product can be a tremendous burden on them. Especially if only one customer asks for...

IF you are dealing with a vendor's DB, why are you attempting to reset the collation? What conflicts are you encountering which motivate the need to change what the...

moh (8/22/2008)

---

That colation change will impact sort order of the data, because:

SQL_Latin1_General_CP850_BIN: is binary sort , on Code Page 850

SQL_Latin1_General_CP1_CI_AS: is Dictionary sort , case-insensitive , on Code...

I don't intend for this to sound offensive, but when's the last time you turned your keyboard upside down and shook it? Is it possible that debris is the...

Congratulations! I'm about to embark on setting up email notifications / alerts when processes fail, for the first time. We'll see how it goes.

IF you are not meticulous about changing the names each time, at every possible location where you can change database names, then you expose and 'dirty' maintenance that the SQL...

That switching over should work for both merge and transactional replications. So, I'm curious as to your rationale for choosing one over the other.