Thank you both for your replies. I had already reindexed the primary key on this table to no avail.

I have run the reindex again though, below is the results which are both at 0% but the space still has not freed up.

name avg_fragmentation_in_percent

sysmail_mailitems_id_MustBeUnique0

sysmail_mailitems_id_MustBeUnique0

sysmail_log_id_MustBeUnique0

As can be seen below after running sp_spaceused the unused space is only 728KB still...totally baffled

name rows reserved data index_size unused

sysmail_mailitems52 6439200 KB6438456 KB16 KB728 KB