I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow?

A. It is recommended that you select/bcp out all the relevant dataand then recreate the objects concerned. However, if you want to attempt arebuild of the extents then make a backup first, and then try the followingafter putting the database into single-user mode first :-

dbcc rebuildextents (@db_id, @object_id, @index_id)

Parameters:
@db_id Id of the database
@object_id Id of the object to be rebuild
@index_id Id of the index to be rebuild

Alternatively you could just rename the object and leave it in the databasewith a dummy name - you won't be able to drop the object.