cannot execute sp_replcmds replication errror

kK-2020 46 Reputation points

i have changed the owner of the publisher database to sa and the log reader agent jobs to sa but the error is still appearing and its failing o replicate
i need to fix this urgently

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,912 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,451 Reputation points

    Hi @kK-2020 ,

    Please see this link check if there is some bad data:
    Narrow down: Select * from sysarticles where filter=1987642274
    Moreover, please provide the errorlog for more information.

    Best regards,