Re: Error when making a transactional replication

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

From: Anders Johansson (anders.johansson_at_nospam.se)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 17:17:17 +0200

Hi Hilary!

The publication database had a different collation than the subscriber.
But I didnīt change the whole subscriber collation - just the article that
went wrong. (There was an alternative in the Publication properties).

Thanks!

"Hilary Cotter" <hilaryk@att.net> skrev i meddelandet
news:%23tQRaguJEHA.3944@tk2msftngp13.phx.gbl...
> your collation on your publication database is different from your
collation
> on the subscriber database.
>
> To solve your problem use the same collation on both databases.
>
> "Anders Johansson" <anders.johansson@nospam.se> wrote in message
> news:OQ9CtRuJEHA.1096@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I'm making a transactional replication.
> > I get the following error:
> >
> > Could not bulk insert. Bulk data stream was incorrectly specified as
> sorted.
> > (Source: SQL4 (Data source); Error number: 4819)
>
> --------------------------------------------------------------------------
> --
> > -----------------------------------
> > Function sequence error
> > (Source: ODBC Driver Manager (ODBC); Error number: S1010)
>
> --------------------------------------------------------------------------
> --
> > -----------------------------------
> >
> > Anyone that knows how to solve the problem?
> >
> > Thanks in advance
> >
> > Anders
> >
> >
>
>

Relevant Pages

  • Re: Error when making a transactional replication
    ... "Anders Johansson" wrote in message ... > The publication database had a different collation than the subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: Rows do not match between Publisher and Subscriber. (Possible
    ... You backed up the publication database, ... the subscriber does not have the schema and data in place option). ... Looking for a SQL Server replication book? ... synctran_commands from the publisher to the subscription manually. ...
    (microsoft.public.sqlserver.replication)
  • Re: Is it posible to have publications with diferent schedules?
    ... single distribution agent by default, going to each subscriber. ... publication database to the same subscription database. ... there can be no different schedules. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication with Locked tables
    ... the publication database as the snapshot is being generated and on the ... subscriber when the snapshot is being applied. ... > replicate some of the tables I see that they are locked... ...
    (microsoft.public.sqlserver.replication)
  • Re: Case Sensitive
    ... on the publisher is case-sensitive and this has replicated to the subscriber ... as a case-insensitive collation. ... need to reinitialize for this to take effect. ...
    (microsoft.public.sqlserver.replication)