sql server replication: Transactional Replication Woes -- sql server replication

Transactional Replication Woes

Jason Wilson
9/27/2006 9:59:49 AM

sql server replication:

Thanks for the response Hilary.

It looks like we lost the rest of the thread so I'll recap:

I am running transactional replication between our radiology
information system database server and a reporting server. I am only
replicating the data we need for reporting. The replication was set up
using the Enterprise Manager using all of the defaults except for the
snapshot location and it is set for continuous updates. The reporting
server is the replication monitor and distribution coordinator.

At least once after the original replication was set up I've been able
to add tables as articles and after running the snapshot agent, the
table was added successfully. Now if I add an article and run the
snapshot agent when it gets to the distribution agent it fails because
it can't find the INSERT/UPDATE/DELETE stored procedures
(sp_msINS_tableName, etc).

If I use the sp_scriptpublicationcustomprocs SP to generate the script
for the SPs and then use those scripts to create the missing SPs then I
have either seen it fail because of missing table schema or missing
modules in the SPs.

I've gotten around this by re-initializing the subscriber, but this
won't be a viable option once this server is in full production.

I've tried rebuilding the replication from scratch but ran into thte
same problem.

Re: Transactional Replication Woes

Hilary Cotter
9/27/2006 1:47:51 PM

This should work. Can you post the name of the problem table here? Perhaps
it is related to naming conventions.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]