Unfortunately, with SQL Server you cannot use the Index or Seek ADO functionality. There's not way around this, although depending on the circumstances, it may help to change your code a bit (or, perhaps, a lot) and rewrite your queries to select more precisely and return less data etc...
>I have created some indexes on a table in the Ms. SQL2000 database, but what's I do not understand is? FYI I use ADO 2.7 and the recordset does not support adIndex, so what should I use to call index on the table? because my application's speed is going down slowly .. please help
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell