Stopping Error 14150 from writing to the SQL Log

Last Post 28 Jul 2008 07:55 AM by leohalim. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
leohalim
New Member
New Member

--
28 Jul 2008 07:55 AM
Hi,
First, let me just admit that I have no experience in setting up a replication. Last month another staff tinkers with the replication. From that date on, I 've been getting two entries on the SQL Log stating that replication is successful.

One line says "Error: 14150, Severity: 10, State: 1"
The other line says "Replication-Replication Distribution Subsystem: agent ..."

The problem is that these two lines show up every three minutes and fill up my SQL log. They make it hard to read the log.

I've tried looking at SQL job and replication monitor where to disable these log writing. The publisher is on another server which is out of my jurisdiction. So far I have not got any response from the guy who tinkered with the replication and I get tired of reading these logs while looking for something worthy. My suggestion to the guy is to disable the successful replication and instead enable the replication failure which is far more meaningful.

Any suggestion for me or to this guy where we should look for to disable the log writing?

Thanks as usual

Leo


Acceptable Use Policy
---