21

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.

Thom A
  • 88,727
  • 11
  • 45
  • 75
Usman Javaid
  • 501
  • 3
  • 7
  • 1
    To repeat what I've said to the last 2 people I've seen ask this question (in as many days): 1. Don't use the "Edit top 200 rows" _'feature'_, it's buggy and quirky. 1b. Use a `UPDATE`/`INSERT`/`DELETE` statements instead. 2. What version of SSMS are you using?" – Thom A Nov 29 '22 at 11:42
  • I am using SSMS v18.10. I can use the queries but "Edit top 200 rows" is easy for quick insert/update/delete and haven't found any problem regarding it so far. – Usman Javaid Nov 29 '22 at 12:46
  • SSMS 18.10 has *no* support for SQL Server 2022. Minimal support for it was added in 18.12, however, if you are using SQL Server 2022 you should be using SSMS 19, which has *full* support for SQL Server 2022. Of course, this doesn't change my point on the "Edit top 200 rows" *feature*; steer clear of it and use T-SQL instead. – Thom A Nov 29 '22 at 12:47
  • But SSMS 19 is actually not yet finished... Beta version only ! – SQLpro Nov 29 '22 at 13:36
  • SSMS is now released, and seems fine for using "Edit top 200 rows" feature. It is really useful when you want to edit say a mapping table where you want to manually review the map say between suppliers or other unstructured/messy data. – Ronald Duncan Mar 31 '23 at 15:21

7 Answers7

29

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

Usman Javaid
  • 501
  • 3
  • 7
5

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.

startmenu

Pete Tashkoff
  • 61
  • 4
3

SSMS 18 will not work correctly for SQL 2022 databases. Use SSMS 19 for SQL 2022 databases.

While certain aspects work with version 18, some simple operations like right clicking a table and selecting "Edit Top 200 Rows" will return just a blank tab with no errors or notices.

Edit Top 200 Rows

Jason Geiger
  • 1,912
  • 18
  • 32
2

server management studio 19 solves the problem

onyangofred
  • 74
  • 5
2

SSMS 19 resolves the problem, but I think it important to echo what Pete said. When you install SSMS19 it installs like an update, but actually installs alongside SSMS18 so you need to make sure you are using right shortcuts etc.

Hac2002
  • 21
  • 4
0

I had the same issue. Then I realize that When UPDATE or DELETE queries with BEGIN TRANSACTION, this issue occurred. Because of I forgot to COMMIT TRANSACTION after UPDATE or DELETE queries.

So I apply to COMMIT TRANSACTION, my issue is solved.

MFD
  • 1
-1

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

Nabi Nabizade
  • 19
  • 2
  • 1
    I have no idea how this is even supposed to be related to the asked question. The question has *nothing* to do with networking. – Thom A Nov 29 '22 at 11:50