Synapse SQL Serverless Stored Procedure Can create but cannot find.

Silvano Paxia 101 Reputation points
2021-02-04T05:30:50.517+00:00

Hello,

I realized I can recently create Stored Procedures in SQL Serverless Pool, but once created I cannot find it.

I can execute without any problem, but there is no way to find in the Database Serverless SQL Pool.

Any idea?

Thanks

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,170 questions
0 comments No comments
{count} votes

Accepted answer
  1. Saurabh Sharma 23,826 Reputation points Microsoft Employee
    2021-02-05T01:05:24.683+00:00

    @Silvano Paxia Thanks for using Microsoft Q&A !!

    Currently you cannot view it on Synapse Studio. However, you can view it from SQL Server Management studio under programmability > stored procedures like it appears for a SQL instance. (see screenshot below)

    64263-image.png

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.