I believe that you will need to compress the nonclustered indexes separately to the tables.
Infact, just checked BOL:
The compression setting of a table is not automatically applied to its nonclustered indexes. Each index must be set individually.
Hope this helps,
Rich
[p]
[/p]