SQL Server Management Studio crash on edit rows

Question

I don't know why, but past week, SQL Server Management Studio started to crash when I try to use "Edit Top 200 rows" option. It happened with 2014 version, but I have installed 2016 version with the same weird result.

Could be a server related problem? A coworker is working without problems with the same configuration.

Thanks in advance.

Answer 1

I had this problem when one of my columns had the char " in it. When I deleted the char " from the column name, it stopped crashing when editing.

Answer 2

You need to upgrade to SSMS Version 18.x.

The Release Notes for SQL Server Management Studio (SSMS) states Bug fixes in 18.0:

Table Designer - Fixed a crash in "Edit 200 rows".

Here V17.9 and V17.9.1 crashed in combination with SQL Server 2019 Express.
The server versions SQL Server 2014 Express and SQL Server 2017 was possible to edit with my old SSMS V17.9.1.

After installation of SSMS V18.4 editing was possible even for SQL Server 2019 Express

Answer 3

I'm on 15.9.8 of VS 2017. Looks like it's broken again.

Answer 4

Finally, I could find out the problem. Visual Studio 2017 messed my computer and broke something. After one of the updates of Visual Studio, Management Studio was repaired too.