MSSQLSERVER_15661

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

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.