sql server replication: Transactional Rep - Is there any wany to Prioritize the article? -- sql server replication

Transactional Rep - Is there any wany to Prioritize the article?

SBR
10/17/2007 6:55:06 AM

sql server replication: Hi,

I'm setting up Transactional Replication betweeen SQL 2K and SQL 2K5.
This includes tables, SPs for replication.

One of the tables is associated with a trigger that invokes a strored
procedure.

And when I initiate the Replication process, the table and SP is replicated
but not the trigger.

I feel, the order of replication is Tables, Associated triggers, and then
Stored procedure. So in this case, SQL Server replicated the table first and
then it tries to replicate the associated trigger. But the trigger needs the
required SP to be available while replicating. If this is correct, Is there
any way to prioritize SP before the table is replicated?

Or is there any other way to solve this problem?

Thanks is advance.
SBR.

Re: Transactional Rep - Is there any wany to Prioritize the article?

Hilary Cotter
10/17/2007 3:32:44 PM

You can replicate the stored procedures first via a pre-snapshot command.
This should solve your problem.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]