>When I trace SQL instructions with SQL profiler on the customer's server, I observe that the "USE ... NODATA" is not converted in SQL as an SELECT statement with "WHERE 1=2" as where clause. The SELECT have no where clause so I think that when view is created SQL extract all data to return view structure.
>Actually my application is very slow on this site especially when the user open a form managed with remote views. When I repeat the same transactions with the same data on my server, I don't have the same performances, it's much faster.
Marc,
You don't need a WHERE clause if select is preceded with "SET FMTONLY ON". Are you and your customer using the same version of SQL Server, the same version of SQL Server ODBC driver? What is compatibility setting for the database in question?
--sb--