I am using a TQuery to do a select * from a table. I have a PC with a very large database, using SQL express 2008 SP1 10.0.2531.0. Through the SQL management studio interface, I can see that my table has 7 million records. The result of the Select * from my table returns 2 million records instead of 7 million. This PC is XP pro, 4 gig of ram.
Using SQL management studio, I backed up the complete database, and re-attached it on another PC using same SQL express 2008 server. Using the same TQuery and doing the same Select * from the table, I see the 7 million records! This PC is Windows 7, 64bits.
I don't understand why the first PC does not show all the records when doing the SELECT.
Any help appreciated!