replication SPs exhibiting inexplicable behavior

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MorDeRor - 29 Aug 2006 16:52 GMT

Hello everyone,

We have SQL 2000 servers connected by transactional replication. We are
using custom SPs to push data accross. Suddenly this morning, replication
started acting strange, to be more descriptive -
one of the articles has 8 columns and is defined to use MCALL type SP for
update.
(veryfied via GUI and sp_helparticle), However, replication is actually
generating a CALL type SP with 14 columns. Any ideas what could be wrong?

Thanks

Reply to this Message

Hilary Cotter - 29 Aug 2006 17:49 GMT

What MCall does IIRC is to only supply changed parameters and the PK values
to the stored procedure, but it still uses the CALL syntax. This is correct
behavior.

Signature

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

> Hello everyone,
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

MorDeRor - 29 Aug 2006 18:12 GMT

thanks Hilary.

BTW, enjoying your book on replication.

> What MCall does IIRC is to only supply changed parameters and the PK values
> to the stored procedure, but it still uses the CALL syntax. This is correct
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message

Hilary Cotter - 29 Aug 2006 18:53 GMT

Why thank you:)

Signature

> thanks Hilary.
>
[quoted text clipped - 20 lines]
>> >
>> > Thanks

Reply to this Message