Post reply

Article exceeded 255 # of col in trans repl

  • June 29, 2003 at 9:48 am

    #80384

    Hi everyone.

    Here is my question...

    I am running SQL 2000, SP 2

    I have transactional replication for database which consists of 11 tables. I have added 17 new columns to one of the tables, but when I am trying to include these new columns into the current replication I am getting an error message saying that this specific table (article) has exceeded number of columns ID 255.

    What's the solution to this problem if you have to replicate table which contains more than 255 columns in it?

    I appreciate your help.

  • June 30, 2003 at 1:18 am

    #463608

    I'm afraid the only option you have is to break up the table into two. SQL Server only supports a max of 255 columns in trans. replication. (for merge it's 246)

    M

    [font="Verdana"]Markus Bohse[/font]

  • June 30, 2003 at 7:00 am

    #463635

    Thank you very much MarkusB!

    I thought may be there are ways around....

    If not, ok tough luck

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

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