Forum Discussion

JoshG3185's avatar
JoshG3185
Copper Contributor
Jun 29, 2022

SQL Server Management Studio Potential Bug

Hi there, Since a week ago we have had a problem when editing SQL tables via the 'Edit top 200 rows' option, but only for features with a Geometry. The first thing I notice is that all geometries hav...
olafhelper's avatar
olafhelper
Bronze Contributor
Jun 29, 2022

JoshG3185 SSMS = SQL Server Management Studio is intended to manage SQL Server, not to edit data.

 

Olaf

JoshG3185's avatar
JoshG3185
Copper Contributor
Jun 29, 2022
Hi Olaf, we do have our GIS and Access front ends for data editing also, but on top of managing SQL Server we use SSMS to edit data through scripts/stored procedures/triggers and on occasion with the Edit top 200 rows. Either someone has made a change or there is a bug where the Edit top 200 rows no longer works where a geometry field exists.
  • JoshG3185's avatar
    JoshG3185
    Copper Contributor
    Jun 29, 2022
    https://www.cadlinecommunity.co.uk/hc/en-us/articles/360000148065-SQL-Server-Spatial-Error-When-Editing-Values

Resources