I have a database that has a lot of text space allocated on a table but not used.
If you do sp_spaceused <table_name>,1 the unused part is 400Mb. I want to reclaim this space, but have not found a valid sybase way of doing it with reorg or dbcc. The only way I have done it so far is to bcp the data out, truncate the table, and bcp it back in again. Not the best really.
Any bright ideas ???