Geek Answers Handbook

Cannot edit Azure database rows in SQL Server Management Studio

I cannot edit or view rows in an Azure database using SQL Server Management Studio. Am I missing something? The option does not exist.

+7
sql-server azure ssms
source share
4 answers

Now you can , you need to have SSMS 2014 with Cummulative Update 5 or later. The latest CU is always listed in the "SQL Server 2014 build versions" KB article .

+20
source share

If you refer to the Select Top 1000 Rows and Edit Top 200 Rows in the table context menu, they are not available in Microsoft Azure Databases. You must use SQL statements to retrieve / modify your data.

Update : from December 18 to 2014, you can do this with the latest SSMS: http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/12/18/sql-server-2014-management-studio-updated -support-for-the-latest-azure-sql-database-update-v12-preview.aspx

+3
source share

If you cannot download the patch for any reason, there is a workaround.

If you create a view, you get the "Edit Rows" context menu. Then you can use the editor that opens to create queries on the actual table, as usual.

0
source share

SSMS 2016 also suffered from this problem. The latest CU (SP1 CU4) fixed this for me.

0
source share

More articles:


All Articles