"Askin Karakas" <askin@ilgaz.net> wrote in message
news:OVRqBbSmEHA.1724@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I am setting up a new queued update - transactional replication using sql
as
> queued commands store. There is no problem about publisher to subscriber
> distribution. But queue reader agent that will deliver transactions from
> subscriber to publisher fails with an error message saying "ODBC
> Error:Could not find stored procedure upd.sp_MSsync_upd_Table_15" .
> There is a sp named sp_MSsync_upd_Table_15 but owner is dbo, not upd. Same
> for ins and del stored procedures
>
> I run profiler and see that queue reader agent calls
> [upd].[sp_MSsync_upd_Table_15] sp to update . Indeed, it must call
> [dbo].[sp_MSsync_upd_Table_15] procedure, change [upd] to [dbo] when
> executing sp.
>
> I checked a running replication system with agent parameter added as
> "-outputverboselevel 2". Though sp_replqueuemonitor shows queued
> transactions will call [upd].].[sp_MSsync_upd_Table_15], I can see from
log
> file and profiler that agent changes upd to dbo and calls correct sp.
>
> I see in log file that agent calls dbo.sp_getqueuedarticlesynctraninfo
> (N'PublicationName', 49) procedure to get actual sp' s for that article.
> That call does not exist in log file of faulty replication system, may be
> this is the problem.
>
> I need a solution without recreating replication if possible
>
> TIA
>
> Askin Karakas
>
>