enable compression

enable compression enables or disables data compression.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

SQL Server Administration

See the Compression Users Guide.