November 14, 2018 at 7:19 am
I was exploring data compression on a server with 'Manage Compression' and got message 'Cannot read property IsEdge. This property is not available in SQL 2016'. I performed the same function on another SQL 2016 server fine. The server with the error is build 13.0.4451(Sp1+CU5) and the one that works is 13.0.4422(SP1+CU2). I am using SSMS 17.2 on both servers. Sp_estimate_data_compression_savings runs fine on both servers.. Am I missing something? Any thoughts?
November 14, 2018 at 7:25 am
I had an issue once years ago with SSMS when checking many tables for compression savings, the only trick I had was restart SSMS in that case, maybe someone else has another solution. Back then SSMS was still shipping with SQL Server Install Media.
November 14, 2018 at 7:36 am
No go on the restart of SSMS. Tried on another server and it worked fine. It was 13.0.4422 but SSMS 17.1. All databases are compatibility mode of SQL 2016.
November 14, 2018 at 7:40 am
Might be an issue with the SSMS Release in use, I hope someone will chime in with a link where you could submit such issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply