Transactional Replication Moniter's distributers to subscribers shows error messages.http://forums.asp.net/t/1552615.aspx/1?Transactional+Replication+Moniter+s+distributers+to+subscribers+shows+error+messages+Thu, 29 Apr 2010 09:41:49 -040015526153810544http://forums.asp.net/p/1552615/3810544.aspx/1?Transactional+Replication+Moniter+s+distributers+to+subscribers+shows+error+messages+Transactional Replication Moniter's distributers to subscribers shows error messages. <p>I am using transactional&nbsp;replication type in sql server 2005 with&nbsp;from many&nbsp;Publishers to one subscriber topology.</p> <p>&nbsp;</p> <p>The Replication monitor's&nbsp;distributers to subscriber tag shows the following error messages.</p> <p>Error messages:<br> The process could not bulk copy into table '&quot;dbo&quot;.&quot;sysdiagrams&quot;'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)<br> Get help: &nbsp;<br> Batch send failed<br> Violation of PRIMARY KEY constraint 'PK__sysdiagrams__08EA5793'. Cannot insert duplicate key in object 'dbo.sysdiagrams'. (Source: MSSQLServer, Error number: 2627)<br> Get help: <a href="http://help/2627">http://help/2627</a><br> &nbsp;&nbsp;<br> To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below.&nbsp; Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)<br> Get help: <a href="http://help/20253bcp">http://help/20253</a> &quot;AUTOERP&quot;.&quot;dbo&quot;.&quot;sysdiagrams&quot; in &quot;C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData\unc\PARI_AUTOERP_REPLICATION_FROM_MSSQL\20100429120926\sysdiagrams_129.bcp&quot; -e &quot;errorfile&quot; -t&quot;\n&lt;x&#36;3&gt;\n&quot; -r&quot;\n&lt;,@g&gt;\n&quot; -m10000 -SERP4 -T -w (Source: MSSQLServer, Error number: 20253)<br> Get help: <a href="http://help/20253">http://help/20253</a></p> <p>&nbsp;</p> <p>Please give me the proper solutions to solve this problem.</p> <p>Thanks a lot.</p> <p>&nbsp;</p> 2010-04-29T09:41:49-04:00