Post reply

replication - error during snapshot agent.

  • June 4, 2002 at 5:37 pm

    #173011

    Doing transactional replication.

    Created publication and subscription. Chose all the tables that need to be replicated.

    Started snapshot agent.

    Snapshot agent failed with the following error message.

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

    and the details of the message are

    Invalid time format

    (Source: ODBC SQL Server Driver (ODBC); Error number: 0)

    ---------------------------------------------

    Any clues on this one ???

  • June 4, 2002 at 5:43 pm

    #430339

    Did you select SQL only for the subscribers, or allow others? I'd suggest trying to duplicate the error by bcp'ing the table in native or character mode.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply