MSSQLSERVER_15661

Applies to: SQL Server

Details

Attribute Value
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.