Azure Data Studio Cannot get to the programmability group for Azure SQL Serverless

Question

I'm having trouble accessing the programmability group for Azure SQL Serverless in Azure Data Studio. For example, when I create a stored procedure in the Serverless pool, I cannot see it or access it. Additionally, the sp_helptext procedure is not supported in Serverless. The only way I can access the programmability group of the Azure Synapse SQL Serverless pool is by opening SSMS.

Is this a feature that you are planning to implement, or is it an oversight?

Answer 1

Hi Jorge L Dominguez •,

Welcome to Microsoft Q&A forum.

As I understand, you could not access Programmability Group in Azure Data Studio to access Stored Procedures of Azure SQL Database Serverless.

I have created test DB Serverless and tried to access in Azure Data Studio as shown below and could find details of the test SP created there as shown below:

Let us know what issue you are experiencing in doing the same, please share configuration details of the Database and error screenshot for better understanding.

Thanks.

Answer 2

Hi Jorge L Dominguez •,

I have checked internally of the question is about Azure Synapse SQL Serverless pool:

“There are no planned improvements to Azure Data Studio for Azure Synapse at this time"

Thanks