I get this error on the Error Creation Initial Snapshot for Transaction Replication:
I had replicaiton for this database setup on 2000 with out any problems.
This replicaiton is from a SS2005 machine to a SS2000 machine.
Error messages:
Message: Data conversion failed
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.WorkerThread.AgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Data conversion failed
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Data conversion failed
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Data conversion failed
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0