[b]Replicating a table with over 255 columns[/b]

[cricketer1]

I am using Win2000 Advanced Server, SQL Server Enterprise.
I have a table that has over 700 columns, but I am able to replicate no more than 255 columns.

How can I replicate the complete table?

Thanks
cricketer1

 

[jby1]

Assuming that the design of the table is the best one, and you really do need that many records in table, you could try creating three tables with a one-one join between them. Then split the fields out between these tables and link them by some sort of key.

 

[cricketer1]

Yes, it seems like I have to do that. I was hoping there may be another way, but I think this may be the best way so far to work around the 255 column limit.

As far as the altering table design is concerned, that may not be feasible at this stage, since this is a telecom production database.

Thanks for your help