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. 

Workaround:

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