Forum Discussion
Solved
Stored procedures on Lakehouse sql endpoint
Hello,
I read few few topics about it here however I have an addtional question. I can creat a stored procedure on a sql endpoint, and I can execute it from the sql endpoint but after creating it, I can't see it in SSMS as an object on the menu tree with schemas, tables, views....
Any ideas?
- Because the endpoint is not a full SQL Server instance, SSMS Object Explorer doesn’t always enumerate Lakehouse procedures under the usual Programmability → Stored Procedures node—even though the objects exist and are runnable. (Also note there’s one SQL endpoint per workspace now; each Lakehouse shows up as a separate database on that single endpoint—make sure you’re connected to the right database in SSMS.)
5 Replies
- Because the endpoint is not a full SQL Server instance, SSMS Object Explorer doesn’t always enumerate Lakehouse procedures under the usual Programmability → Stored Procedures node—even though the objects exist and are runnable. (Also note there’s one SQL endpoint per workspace now; each Lakehouse shows up as a separate database on that single endpoint—make sure you’re connected to the right database in SSMS.)
I have tested it - seems to be working for me.
It wasn't visible there. That's why I posted the question.
That's right, it seems there is an isssue with lakehouse.
Hi MorenaBI It should be under Programmability > Stored Procedures folder in the menu tree if you're using SSMS v19+.
You can also find it if you're using VS Code extension SQL Server (mssql).
