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.