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...
- 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.)
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.)
That's right, it seems there is an isssue with lakehouse.