Hi Bill,
In essence, yes, SQL Server frees up the space taken by deleted records. If you have ever recalled records after deleting them in VFP, then you get the idea of how SQL Server does its thing. Honestly, it's more complicated than that (e.g., index updates don't happen immediately) but basically it reclaims the space as it is needed.
>Does it remove the row and free up disk space or ???
>
>Thanks,
>Bill
-Chuck Urwiler, MCSD, MCDBA