>Good points, I will check for deleted records. Is there a way in SQL Server to optimize tables (like a pack in VFP?) The settings should be the same because the databases were created with the same code. If it's due to deleted records a "Pack" should bring the two databases closer in size, just to get reaffirmation. The percentage is quite high, around 40% less.
I don't think there is command in SQL Server which is similar to VFP pack, at least, I don't know of a documented way from the top of my head.
If it's not broken, fix it until it is.
My Blog