Well, you could get more precise by calculating the max row size and then multiplying that by the estimated number of rows. For example, just to make things easy, let's say you have one table with 3 columns: 1. Integer (4-bytes) 2. varchar(6) (6-bytes) 3. varchar(10) (10-bytes) Total row size = 20b Total table size = 20b * 1000 rows = 20,000b = 19.5kb
Of course that's just data storage size.
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"