Hi Gail,

Unfortunately the Compress keyword is an Enterprise Only feature.

It is only backup compression that is in the standard product.

This code runs on 1400 SQL Servers, so upgrading is not an option (yes, I did try).

We use it on our Data Warehouse system, where it really helps, also on FLOAT, DECIMAL etc columns.

Best regards,

Henrik