SQL Server Manage Compression Inactive

  • I want to manage compression but when i press the database-tables and right click on the table name storage menu shows manage compression is inactive on my SQL server 2016. I have sysadmin privileges. How i can make it active ? My autentication is windows authentication.

  • berhankoc - Wednesday, January 18, 2017 3:38 AM

    I want to manage compression but when i press the database-tables and right click on the table name storage menu shows manage compression is inactive on my SQL server 2016. I have sysadmin privileges. How i can make it active ? My autentication is windows authentication.

    I solved this myself. This is microsoft bug. Who will encounter with this problem you shoud do this operation with TSQL.

    https://connect.microsoft.com/SQLServer/feedback/details/3104616 

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply