SQL Server Performance Forum – Threads Archive

Replication – Help!

I have a snapshot on one that is sending a large table and I keep getting the following error: The process could not bulk copy out of table [dbo].[syncobj_0x4433303538463531] I’m at a loss. Can somebody please help? Thanks!

---

HEre’s some input from ReplicationAnswers.com Error Messages…….Snapshot error: The process could not bulk copy out of table ‘[dbo].[syncobj_xxxxxxxx]’. Error Details: ODBCBCP/Driver version mismatch ——————————————————————————– There are some reports that this problem can be solved by upgrading to a consistent MDAC versions on both machines. To determine the version currently installed, there is a free downloadable tool here. The following files must have matching file versions: %SystemRoot%system32sqlsrv32.dll
%SystemRoot%system32sqlsrv32.rll
%SystemRoot%system32odbcbcp.dll Where does this originate from? Possibly from a failed/partial installation of MDAC qfe(s). ***********************
Dinakar Nethi
SQL Server MVP
***********************

---

I thought I’d share the solution to this problem. It turns out that there was an extremely long-running query. When this was replicated it kept timing out. What I did to solve this was I increased the QueryTimeOut parameter from the default of 300 seconds to 90000 seconds and that allowed it to go through. Thanks again!

---

]]>