>I found out that SQL 6.5 holds 16K for text fields. (we have two text fields for each table)
That's correct. SQL Server 6.5 will allocate a min. of 2K for a Text column.
>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.
You might be better off using Text datatypes in SQL Server 7.0. 7.0 allocates only the space that you need (well almost). It has much better space usage. Check out the topic
text, ntext, and image data in the SQL Server 7.0 BOL.
>I think this sounds right. Good News though...the client this week is buying SQL 7.0...Yaaaaaa!!! :)
I agree. 7.0 is a much better product. Your client will be very happy.
>Again, Thanks for the reply, you have helped me out twice know thanks alot.
Your welcome! It's been fun.
-Mike