• Does this table have a clustered index? Because heaps (tables without a clustered index) essentially can't be defragmented: the only way to approximate it is to create another table and copy all records into the new table.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?