IMO, stored procedures still provide the interface to the client. The other objects that you mentioned can and should be taken advantage of for the implementation of that interface.
In general, performance comes from a good schema and even better indexes. Follow known best practices and spot optimize as needed.
-Mike
>Hi,
>
>SQL2K
>
>I have been using stored procedures to return result sets to VFP Front end cursors. It works very well. But - since I'm always looking for a better or faster way to do things, I want to consider using either SQL Server Views (NOT VFP Remote Views!) or possibly UDF() to return my result sets to my cursors - which may as simple as "select * from table", or as complex as 10-12 level inner/left joins using dynamic SQL and passed in where clauses.
>
>Any comments as to advantage (if any) of SQL views or UDF or stored procs?
>
>TIA,