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