Post reply

Could Not Copy Buld Data

  • October 9, 2005 at 1:13 am

    #90211

    I have set up transaction replication between two servers.  When i go to add an additional table i get the following error

    Could not bulk insert. Bulk data stream was incorrectly specified as sorted.(Source: CD5540AB (Data source); Error number: 4819)

     I have run sp_helpsort and both server are on

    Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

     

    Any Ideas would be help full.

  • October 10, 2005 at 10:48 am

    #596331

    Are you adding the table after you have created the publication and snapshot ??

    Are you adding the new table via GUI or sp_addarticle ??

    Don't count what you do, do what counts.

    SQL Draggon

  • October 11, 2005 at 4:04 pm

    #596675

    i am adding the table to the article via the GUI.

  • October 26, 2005 at 2:10 am

    #600035

    Hi,

    I had the same problem.

    I solved it selecting the "collation" flag in the "Copy objects to destination properties" (In the table specified in the error message).

    Just try it

     

    Hope this helps

Viewing 4 posts - 1 through 3 (of 3 total)

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