Thursday 7 March 2024

USE statement is not supported to switch between databases. Use a new connection to connect to a different database.

This issue occurs because Azure Managed Instance and Azure SQL Database does not support the "use" command. 


To work around this issue, select the correct database first in the SSMS database drop-down list, and then execute the stored procedure.