SQL Server 2005 Transaction Replication

• sekhar.k

  SSC Veteran

  Points: 232

  More actions

  June 11, 2008 at 10:57 pm

  #192411

  Hi, Please help me I'am getting follwing Error freequently in SQL Server 2005 Transaction Replication.

  Error messages:

  The process could not execute 'sp_MSadd_replcmds' on 'REPOSITORY'. (Source: MSSQLServer, Error number: 1007)

  Get help: http://help/1007

  The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions. (Source: MSSQLServer, Error number: 1007)

  Get help: http://help/1007

  IDistPut Interface has been shut down. (Source: MSSQL_REPL, Error number: MSSQL_REPL2000)

  Get help: http://help/MSSQL_REPL2000

  The last step did not log any message! (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)

  Get help: http://help/MSSQL_REPL22037

  Regards

  sekhardba2005@gmail.com

• MohammedU

  SSCoach

  Points: 19644

  More actions

  June 12, 2008 at 12:41 pm

  #828058

  Based on the error you have blocking issue going on...

  did you check if there is any blocking happening during this?

  How to monitor blocking in SQL Server 2005 and in SQL Server 2000

  http://support.microsoft.com/kb/271509

  MohammedU
  Microsoft SQL Server MVP