Re: Transactional Replication Problem

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: 01/11/05 

Date: Tue, 11 Jan 2005 08:14:30 -0800

I'm using a web browser so can't see your attached file -
can you put the script in a post and I'll take a look.
Rgds,
Paul Ibison

>-----Original Message-----
>I already fixed the order problem, but the main problem
in delivering the
>update commands to the distribution database it doesn't
goes to the
>distribution
>
>Ahmed
>
>
>"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in
message
>news:20fa01c4f7ea$f5e5e9f0$a401280a@phx.gbl...
>> Just tested this and it's my mistake. SQL is replicated
>> without the column list, so you were right.
>>
>> On Publisher: INSERT INTO tTestOrdering (num1, txt1,
>> num2, txt2, id)
>> VALUES (1, 'aaa', 2, 'bbb', 999)
>>
>> Replicates as: Insert into "tTestOrdering" values
>> (1, 'aaa1', 2, 'bbb1', 1000)
>>
>> So with difftrent orders on the publisher and
subscriber
>> this produces the error : "Syntax error converting the
>> varchar value 'bbb1' to a column of data type int.".
>>
>> Rgds,
>> Paul
>
>
>.
>

Relevant Pages

  • RE: Copy database
    ... > If this is not viable, you could create a script of the ... > system and apply it to the test system. ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem in creating snapshot for merge replication from a script
    ... Paul Ibison ... Rights seems the culprit for I ran the same ... script on another sql server 2005 box and instance, ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge replication and dynamic filters question
    ... I ran the script you attached but unfortunatly - it still doesn't work. ... The subscriber still gets the whole FileProperties table and not only ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Diff. transactional publications ; synchronizing at diif. time
    ... this publication. ... "Paul Ibison" wrote: ... > the results along with the script you are using for the second subscription ... > (or just explain it if it's not a script). ...
    (microsoft.public.sqlserver.replication)
  • Re: how to show progress percent
    ... the replication ActiveX controls have this functionality. ... Unfortunately you have to use the status event which is not accessible from a script. ... "Paul Ibison" wrote: ... > Out of the box for standard initialization this is not possible. ...
    (microsoft.public.sqlserver.replication)