Reclaiming space using bcp

To reclaim space with bcp:

1. Use bcp to copy the table to a file.

2. Use truncate table to truncate the table, reclaiming unused space.

3. Copy the table back in again with bcp.

For detailed information about working with partitioned tables, see Chapter 10, “Partitioning Tables and Indexes,” in the Transact-SQL Users Guide.

For more information on bcp, see the Utility Guide.