Post reply

transactional replication

  • July 2, 2009 at 7:28 am

    #207879

    Table consists of greater than 254 columns,i am tring to replicate that table,then it failed.

    using replication type is transactional.

    How to replicate that table.

    Thanks in advance.

  • July 2, 2009 at 7:44 am

    #1019152

    Transactional replication supports upto 1000 columns per table, what is the error message thar you are getting?

  • July 2, 2009 at 7:54 am

    #1019160

    a column have unique index and PK(in that table), is it possible.

  • July 2, 2009 at 7:59 am

    #1019163

    charipg (7/2/2009)

    a column have unique index and PK(in that table), is it possible.

    I am not sure if I understand this statement/question,

    However regarding PKs -- All published tables in transactional replication must contain a declared primary key

  • July 2, 2009 at 8:02 am

    #1019166

    That table have a identity column.should i delete identity property?

  • July 2, 2009 at 8:09 am

    #1019171

    charipg (7/2/2009)

    That table have a identity column.should i delete identity property?

    Is the identity column your primary key? if so i would not delete it, Identity columns can cause problems with Merge replication, but with one-way transactional replication i have not had any issues.

    The best next step would be to check the log to see why the replication is failing..

  • July 2, 2009 at 8:12 am

    #1019177

    thanks ............

Viewing 7 posts - 1 through 6 (of 6 total)

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