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

Time:12-01

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.

CodePudding user response:

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

CodePudding user response:

Did you recently install multiple .NET Framework applications and MS software? If so, you might need to reset your network adapter.

Try running the following command in CMD (Run as Administrator):

netsh winsock reset

  • Related