>If you have an advice about moving from remote views to cursor adapter, I would be very grateful.

I recommend using Mark McCasland's CursorAdapter builder, since it can automatically generate CursorAdapters for each of your SQL Server tables.

Doug