"Edit Top 200 Rows" not working for SQL Server 16.0 - Express Edition

Question

I am trying to "Edit top 200 rows" in SQL Server Express edition, but it's returning with the blank file as shown here:

Showing blank file with disable tools

I have installed this SQL Server on premise. I can select the data and update the data with query, but I'm not able to use the "Edit top 200 rows" feature.

Am I missing some permissions or its not available due to this SQL Server version which include Azure?

I have re-installed SSMS and restarted machine but it doesn't work. I have checked the permissions which are sysadmin. It should work so I can update data directly in the rows.

Answer 1

SSMS 19.0 resolved my issue. SSMS 18.10 has no support for SQL Server 2022.

Answer 2

Installing SSMS 19 resolved the issue for me too.

Available at this link: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms-19?

A point to note, I could not locate the version 19 immediately using type-ahead. But it can be located clicking the start button and scrolling down.