Command attempted:Lookup the executed command by viewing the call (see my previous post) and update the stored procedure by commenting the rowcount check
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000013DC0003277A006D00000000, Command ID: 2)
Error messages:
The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: 20598)
Get help: http://help/20598
The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: 20598)
Get help: http://help/20598
ALTER procedure [dbo].[sp_MSdel_genTokenBalance] @pkc1 varchar(19) as begin delete [gen].[TokenBalance] where [TokenNumber] = @pkc1 --if @@rowcount = 0 -- if @@microsoftversion>0x07320000 -- exec sp_MSreplraiserror 20598 endNOTE: don't forget to restore to the original when the problem is solved.
Good luck!
No comments:
Post a Comment