>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

The number of columns is ca. 255.

I don't know of a work-around - perhaps SQL server has the option to create something like a "virtual table" - however they call it -, something like a view, where you include only fields that are of interest to you.

And indeed, I think your "not me" is justified - more than 255 fields is usually an indication of a bad design.

Hilmar.