MSSQLSERVER_15661

  • Article

Details

Product Name

SQL Server

Product Version

11.0

Product Build Number

11.00.0000.00

Event ID

15661

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

SQLErrorNum15661

Message Text

The sp_estimate_data_compression_savings stored procedure cannot be used for temporary tables.

Explanation

A temporary table was used as an argument for the sp_estimate_data_compression_savings stored procedure. Although the compression of temporary tables is supported, you cannot use sp_estimate_data_compression_savings to estimate the compression savings.

User Action

Remove the temporary table as an argument for sp_estimate_data_compression_savings.