>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.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown