I am using ADO to access MS-SQL server.
I understand server side cursor cause the server to copy some data about
the rows into tempdb
also i have read that client side cursor bypass the tempdb.
My question are:
1.If i am using Recrodset.CacheSize=1 what exactly happen
to the records..?
2.Can i see the tables which created in tempdb due to query processing...?
3.Two users open server side,read only cursor with the same
connection property and same SQL query,how many table
will tempdb create...?
thanks in advance