Thanks Craig for the reply after much searching and lots of reading. I finally can to the conclusion that the two systems operate totally different from one another in space used.

I'm sure you know this but just to be sure that we are on the right track i will run it by you.

I found out that SQL 6.5 holds 16K for text fields. (we have two text fields for each table)

The design was built in FoxPro where we could allocate space for Memo fields.

We moved this design to SQL 7.0 which only uses 1 page (varchar design) for allocating space not 16K. I guess that is why the database at our office in SQL 7.0 is only 30M and the log is .50M while the 6.5 database is 1Gig and the log included in the 1Gig.

I think this sounds right. Good News though...the client this week is buying SQL 7.0...Yaaaaaa!!! :)

Again, Thanks for the reply, you have helped me out twice know thanks alot.

Shawn