>Hi there.
>
>Another consultant (not me ;-D) recently edited a database on one of our SQL servers and added a LOT more
>fields to a specific table.
>
>Now I can't create a remote view on that table .. if I try to add the table to a new remote view .. I get a "too many columns" error.
>
>-> What is the maximum number of columns that a remote view can handle?
>-> Is there any way around this issue with remote views?
>
>TIA, Scott :-D

Create a view in SQL Server of the data you need and create your remote view against it. I would say that you may want to reevaluate your tables design, however.