Comments Inline
>sp_spaceused shows..
>database_name database_size unallocated space
>------------------------------ ------------------ ------------------
>MyDBName 1600.00 MB 292.79 MB
>
>
>reserved data index_size unused
>------------------ ------------------ ------------------ ------------------
>1338584 KB 1002532 KB 334226 KB 1826 KB
>
>
>Why does the second line show only 1.8 meg free?
It doesn't say that exactly. SQL Server 6.5 is a very strange animal. When you create an object, SQL Server allocates an entire extent or 8 pages to the object. That's the reserved number. If you have a table that takes only 1 page, SQL Server will still allocate the other 7 pages to it and call it unused.
You database has ~292MB that has not been allocated to any object.
>Does any of this give you any hints?
Does the table have a text or image columns? For instance, a VFP memo or general field. When you create a text column in 6.5, every row will require a minimum of 2K, even if the the values in the memo are much smaller. This is just the way it works in 6.5. The only way the 2K page won't be allocated is if the column has a NULL value. If you don't really need any memo or general field info, don't upsize it.
-Mike