Post reply

Trans replication does not support more than 255 columns

  • February 4, 2004 at 12:07 pm

    #84564

    Hi everyone

    We have Windows 2K advanced server with SQL 2K enterprise on it. We using

    Trans replication for one of the our databases. We have very intensive

    production env so every min of down time is very expensive, it critical for

    us to have a backup system in sync

     

    with our primary replicating updates as soon as they occur.

     

    From time to time we adding new columns to a database which I

     

    have to include in to the replication. Everything was fine up untill I had

    to add 256th column to a specific table,

     

    I got the error message that SQL does not support more than 255 columns for

    Trans Replication. Did anyone had the similar problem, is there a way

    around? Please help. Thanks in advance.

  • February 6, 2004 at 11:07 am

    #493139

    Just to clarify, when you filter the publication vertically you can have the destination tables as Table1 and Table2 and then create a view on the 2 tables at the subscriber to combine these into one view with > 256 columns

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

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