Home Forums SQL Server 2005 Administering Replication Error, The process could not execute 'sp_MSpub_adjust_identity' on 'Servername'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) RE: Replication Error, The process could not execute 'sp_MSpub_adjust_identity' on 'Servername'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

  • February 23, 2010 at 2:56 pm

    #1123909

    Tracer tokens comes to your rescue. Read about one such procedure mentioned by Chad at http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/24/monitoring-replication-latency-automatically-using-tracer-tokens-sp-replchecklatency-allpubs.aspx.

    HTH!

    MJ