>And don't for a second think that using cursors in SQL Server is a viable approach. They are slow as molasses.

I'm planning to use SQL Server as a back end to a client server app with these LARGE (2G+) tables using FoxFire! - I figure if I send the query to SQL Server, it should handle it better than it can in fox- don't you think?

It's really not a question of transactions for me - it's a question of speed of queries of large tables....