Forum Discussion
SSMS Edit rows hangs if open for long time
If you have Edit rows open for a long time (~1h) and submit a change, SSMS (v20.2) sometimes hangs. There's no errors or anything visible and the application becomes unresponsive (sometimes there's a "SSMS is busy"-notification and has to be killed. Feels like the value submission is missing refresh token and/or error response handling. Update does not get processed, but always a bit scary if I had something else open that was. Not sure if there's a way to report such bugs.
4 Replies
I have no problems with SSMS.
SSMS = "SQL Server Management Studio" is mainly intended to manage SQL Server and run queries.
The feature to edit data is more a small gimmick, which may work or may make trouble.
Use a real frontend to edit data.
Should still fail gracefully enough without hanging whole app. The problem is usually not the edit that fails but having a different SQL statement in some other tab ready to execute that get's lost. I can live with SSMS unable to refresh an access token but having the whole app crash is a problem.
Same goes for SSMS 21 too... Event 10 minutes, will start a lock which needs restart of SSMS.
