>- Get a cursor from customers containing about 50 000 records
>- Get a cursor from Transactions containing abount 500 000 records
>- Make some changes to each customers
>- Copy the 500 000 transaction records to a history table (Same structure)
>- Start sending back to SQL Server 2000
Do all of these operations have to be handled under the same transaction? Can you commit the changes to the customers before copying their transactions to history?
>> - Start sending back to SQL Server 2000
Are you doing all of these operations from outside SQL Server? What are you copying back?
-Mike