By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,983 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,983 IT Pros & Developers. It's quick & easy.

Order of Merge Replication

P: n/a
Hi, this is a repost from the SQL Server group.

I am wondering if it is possible to change the order that articles are
propagated to the subscriber. I currently have a table, say table A
that is used in view B. However, for a variety of reasons I need to
change the name of the table to C and create a new view called A.
However, view B is being replicated before view A is being replicated
and it is generating an error, "The script file for view B cannot be
propagated to the subscriber."

I'm hoping that by replicating view A first I should be able to avoid
the error.

Any help would be appreciated. I hope my explaination is clear enough.

Thanks,
Cameron

Sep 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I should also add that this is for SQL Server 2000.

Cameron wrote:
Hi, this is a repost from the SQL Server group.

I am wondering if it is possible to change the order that articles are
propagated to the subscriber. I currently have a table, say table A
that is used in view B. However, for a variety of reasons I need to
change the name of the table to C and create a new view called A.
However, view B is being replicated before view A is being replicated
and it is generating an error, "The script file for view B cannot be
propagated to the subscriber."

I'm hoping that by replicating view A first I should be able to avoid
the error.

Any help would be appreciated. I hope my explaination is clear enough.

Thanks,
Cameron
Sep 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.