>Hey all,
>
>I recently began experimentation of using SQL Server as a back-end instead of DBFs. I am familliar with upsizing and the basic use of the CursorAdapter. I am comfortable generating simple, updatable data-sets as wel. What has me in a ringer is that I need to use these tables' existing indexes. Would someone please give me a general run-down on the best-practice of migrating indexes to SQL from a DBF, and their use in a CursorAdapter generated cursor?
>
>Thank you,
>-John

No use of existing indexes. SQL Server use indexes only to speed up queries. There is no such commands as SEEK in SQL Server. All youcould do is first to try your queries in Query Analizer/SQL Server Management Studio and turn on Execution plan and when all is Index Scan then all is OK. BUT you must be careful, if you have many indexes this will spped down all other activitie, especialy updates and inserts.
When you use CAs don't try to get whole table, query only these recorsd that you need in current situation, than index CA cursor in AfterCursorFill event and youcould use this index as well as you use Native Tables ones.