Can I shrink a table in SQL Server 2000?

I have a table that has a ton of unused space in it (1.8 GB). Is there any
way to shrink just a table or do I have to shrink the whole DB to recover
that space?
Thanks,
Davehave you try to defrag your indexes?
specially the clustered index.
also, what is your index fill ratio?
I don't remember if SQL 2000 has this function, but in SQL 2005 you can
recover unused space of the varchar columns.
I don't remember the command, maybe you can search for this.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:5D9FF2D4-307A-48F1-BBB6-3FE4D568464B@.microsoft.com...
>I have a table that has a ton of unused space in it (1.8 GB). Is there any
> way to shrink just a table or do I have to shrink the whole DB to recover
> that space?
> Thanks,
> Dave