The process could not bulk copy out of table '[dbo].[syncobj_

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 09/23/04


Date: Thu, 23 Sep 2004 00:46:37 -0700

This could mean that the snapshot agent timed out or was
blocked. Try stopping and restarting the snapshot agent.
If you are dealing with a large table, you may need to
manually transfer it to the subscriber.
If the complete error message is something like this:
"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. Also, check the version of the
ODBC32.dll. It could be the one that is mismatched. It
should be version 3.525.1022.0.
HTH,
Paul Ibison

 (recommended sql server 2000 replication book:
 http://www.nwsu.com/0974973602p.html)



Relevant Pages

  • The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION...
    ... This article is titled "The Snapshot Agent fails and a "The COMMIT ... TRANSACTION request has no corresponding BEGIN TRANSACTION" error message ... Does anyone out there have a reliable solution to this problem that I can ...
    (microsoft.public.sqlserver.replication)
  • Re: The process could not bulk copy out of table [dbo].[syncobj_
    ... I am getting "Datetime field overflow" error. ... Try stopping and restarting the snapshot agent. ... > version mismatch", there are some reports that this ... > problem can be solved by upgrading to a consistent MDAC ...
    (microsoft.public.sqlserver.replication)
  • Re: problem with a table
    ... Try stopping and restarting the snapshot agent. ... If you are dealing with a large table, ... (recommended sql server 2000 replication book: ...
    (microsoft.public.sqlserver.replication)
  • Re: merge replication, snap shot failure at publisher
    ... this usually means the snapshot agent was timed out, blocked, or somehow ... Try stopping and restarting the snapshot agent. ... If you are dealing with a ...
    (microsoft.public.sqlserver.replication)
  • Assert failed
    ... I receive the following error message when the snapshot agent runs on ... my merge publications. ... MSSQLServer, Error number: 12241) ...
    (microsoft.public.sqlserver.replication)