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.