Post reply

Number of columns greater than 255

  • February 1, 2005 at 11:11 am

    #88008

    Hi everyone,

    any ideas how to replicate a table in SQL Server 2000 with number of columns greater than 255. I'm trying to filter the table to replicate only 100 columns but the process fails with the error that # of columns exceeds 255...

    Thank you, Mike.

  • February 2, 2005 at 2:09 pm

    #540255

    I don't believe that this is possible with SQL2K.  Per BOL, "A table used in a snapshot or transactional publication can have a maximum of 255 columns and a maximum row size of 8,000 bytes."  This is under the article "Publishing Data and Database Objects".

    Personally, I'd say if you have a table with 255 columns you need to break that table up.  To preserve existing Select functionality you could create a view, but you would need to re-write any Insert/Update/Delete procs.

    cl

    Signature is NULL

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

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