I connected SSMS to an Azure database. Now I can't easily select top rows by right clicking, can't design views, etc.... like I can with local SQL Server databases. How can I get this functionality for an Azure database? Thanks
2
votes
Have you read this: dotnet.dzone.com/articles/connecting-sql-azure-sql
- Tanner
Yes @Tanner. I'm already connected fine to the Azure db view SSMS. The issues is that several standard options/functions are not available for Azure tables/views, etc..
- WebDevGuy
See this answer and the link it references: stackoverflow.com/a/14764234/57475
- Tanner
1 Answers
2
votes
If you have not done so, please update to v12 of Azure SQL Database and also please make sure you install the latest updates for SSMS. These updates will allow you to right-click on a table to "Select top 1000 rows", "Edit top 200 rows", or open "Design".
