Monday, March 12, 2012

new publication deleted before snapshot completed

I just created a new publication and subscription... And was in the middle
of the synchronization when I dropped the publication...
I am now receiving a 'Could not find stored procedure 'sp_MSins_tablename''
for all of the agents replicating to this server/db.
The error code is 2812.
Anyone encounter this and have an easy solution?
Thanks in advance!
~lb
Hi,
You can remove all the entries manually or use sp_removedbreplication
'databaseName' to start all over again.
Hope this helps.
cheers
"Lonnye Blake Bower" wrote:

> I just created a new publication and subscription... And was in the middle
> of the synchronization when I dropped the publication...
> I am now receiving a 'Could not find stored procedure 'sp_MSins_tablename''
> for all of the agents replicating to this server/db.
> The error code is 2812.
> Anyone encounter this and have an easy solution?
> Thanks in advance!
> ~lb
>
>

No comments:

Post a Comment