Error Message “The Process Could Not Execute ‘Sp_Replcmds’” in SQL Server

In MS SQL Server 2000, the replication process usually runs without any issue for more than 377 days. But once these 377 days get over problem arises while accessing the Server. So when the user tries to run the SQL Server 2000 Transaction Replication, he gets an error message:

“The process could not execute ’sp_replcmds’ on ’servername’. An invalid datetime value was encountered. Value exceeds the year ####”.

Cause

It’s not hard and fast rule that this particular will come only after 377 days; rather this error can come even before 377 days time. This is basically a problem with the user’s log reader agent. The user can change the default profile settings for Query Timeout and ReadBatchSize to 1 for the log reader and then he can restart the log reader agent.

But, most of the times, even after restarting the LogReader, user get the above error message again. In such cases, it’s highly recommended that you must take help of third party tools to safeguard your SQL Server for any mishap and further corruption.

Resolution

If you want to eradicate the above mentioned error, using Kernel for SQL Recovery software would be of great help to you. It is one of the best and smartest utility available that strives hard to perform SQL recovery under any circumstance.

Comments are closed.