cannot execute sp_replcmds replication errror

kK-2020 46 Reputation points
2022-03-02T01:12:56.003+00:00

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
    2022-03-02T06:41:37.257+00:00

    Hi @kK-2020 ,

    Please see this link check if there is some bad data: https://www.sqlservercentral.com/forums/topic/the-process-could-not-execute-sp_replcmds-even-after-reinitialization
    Narrow down: Select * from sysarticles where filter=1987642274
    Moreover, please provide the errorlog for more information.

    Best regards,
    Seeya