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.
0 comments No comments
{count} votes

Answer accepted by question author
  1. Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
    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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.