Edit Data in Azure Data Studio stopped working for me

Horst Schnattler 0 Reputation points
2024-06-22T18:56:21.68+00:00

I usually edit fields in tables manually with Azure Data Studio by clicking right on the table and selecting 'Edit Data'.

However it stopped working for me, the screen is loading and nothing happens, sometimes I get an error message that there is already an active Edit session.

I displayed my current connections with :

SELECT session_id, login_name, status, host_name, program_name

FROM sys.dm_exec_sessions

WHERE database_id = DB_ID('YourDatabaseName')

AND host_name = 'YourHostName';

And there are active connections that I cannot kill with this, the connections remain even after killling them:

-- Replace 'YourDatabaseName' with the name of your database

-- Replace 'YourHostName' with the host name

DECLARE @DatabaseName NVARCHAR(50) = 'YourDatabaseName';

DECLARE @HostName NVARCHAR(50) = 'YourHostName';

DECLARE @SQL NVARCHAR(MAX) = N'';

-- Build dynamic SQL to kill all connections from the specified host

SELECT @SQL = @SQL + 'KILL ' + CAST(session_id AS NVARCHAR(5)) + ';'

FROM sys.dm_exec_sessions

WHERE database_id = DB_ID(@DatabaseName)

AND host_name = @HostName

AND session_id <> @@SPID;

-- Execute the dynamic SQL

EXEC sp_executesql @SQL;

Help!

Thank you

Horst

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 33,421 Reputation points MVP
    2024-06-23T00:10:44.74+00:00

    The February release of Azure Data Studio (v1.48.0) brought a fix for a bug on Edit Data. Could please try update to the latest version or at least install the February release. You can download the latest version (June 2024 release) from here.


  2. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2024-06-24T14:04:01.1866667+00:00

    Thanks @Alberto Morillo for your contribution, Thanks @Horst Schnattler for providing your solution I'm glad that you were able to resolve your issue and very much appreciate that you have posted your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

    Issue: You are facing an issue where you are unable to edit fields in tables manually with Azure Data Studio by clicking right on the table and selecting 'Edit Data'. The screen is loading and nothing happens, and sometimes you get an error message that there is already an active Edit session. you have also tried to kill the active connections but remain the same.

    Solution: As you were able to resolve the issue! by increasing the size of minimum vCPUs to 2.

    If you have any other questions or are still running into more issues, please let me know.

    Please remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution.

    Regards

    Geetha

    0 comments No comments