..Snippage..
>Are you trying to free up space or restructure you database to seperate the data and log segments?
>
>-Mike

My goal is just to get the other 600,000 records into the table so that I can perform a test, then delete the whole thing and forget it!

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?

sp_helpdb gives....

name db_size owner dbid
------------------------ ------------- ------------------------ ------
MyDBName 1600.00 MB sa 8

device_fragments size usage
------------------------------ ------------- ----------------------------------
MyDBName 1300.00 MB data and log
MyDBName 300.00 MB data and log


device segment
------------------------------ ------------------------------
MyDBName default
MyDBName logsegment
MyDBName system


So the new 300Mb fragment is available. When I look at the DB size in the Enterprise manager it shows the expected 1600MB, but 0 free space (as mentioned before).

Does any of this give you any hints?