You could
1) Break the table up into smaller tables, with none of these new tables having the same name as the old table.
2) Create a SQL Server view that joins these tables back together. Name this view the same as the old table.
Code that accessed the old table shouldn't have to be changed.
This might also improve performance, since when you select specific fields from a view, it will only hit the tables it needs to.
Of course, I'm not sure where the code you indicate would have to be changed is located. :)
>Hello,
>
>I have a table with 650 fields that I need to replicate.
>SQL Server 2000 replication limits you to table with 255 fields or less.
>
>What would be my options here ?
>1-Push all records with a DTS (too long)
>2-Break the table into smaller ones (too much code changes)
>3-Push the changes with a DTS (too much code changes)
>
>Any other options ?
>
>
>Thanks
Insanity: Doing the same thing over and over and expecting different results.