Cannot browse programmability (stored procedures) under ondemand pool

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.

https://learn.microsoft.com/sql/azure-data-studio

MIT License

7.57k stars 900 forks source link

Cannot browse programmability (stored procedures) under ondemand pool #24557

Open YorBraakman2022 opened 1 year ago

YorBraakman2022 commented 1 year ago

SSMS: ADS:

The folder programmability is not available in ADS, it is in SSMS.

Alter statements work fine, however I'm really missing the feature.

sharpt00th commented 1 month ago

As well as Lakehouse databases, this is also the case for Azure SQL databases that sit in an "ondemand" serverless SQL environment, in ADS these will show Tables, Views, External Resources and Security, but not Programmability.