Post reply

Publications error 20068

  • February 6, 2007 at 2:36 pm

    #172021

    When I created publications in SQL Server 2000 run into error of:

    SQL Server Enterprise Manager could not create article 't_TurbTable_MWT92Daily' based on object 't_TurbDataMWT92Daily'

    Error 20068: This article cannot be created on table '[dbo][t_TurbDataMWT92Daily] because it has more than 255 columns.

    Did anyone know this issues?

    How to resolve it?

    Thanks.

    TJ

  • February 6, 2007 at 3:54 pm

    #688161

    Hi Room,

    I found an article from Microsoft sites. The SQL Server 2000 cannot replicate a table with more than 254 columns. It is behavior of SQL Server 2000 by design.

    http://support.microsoft.com/kb/310631

    Thank you.

    Edwin.

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

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