Assume that you use Microsoft SQL Server 2014 Management Studio (SSMS) and connect to Azure SQL Database. When you run the command Execute Stored_Procedure_name
from the right-click shortcut menu of a stored procedure, after filling out the fields in the appearing dialog window and clicking OK
, you receive the following error messages:
Msg 40508, Level 16, State 1, Line 1
USE statement is not supported to switch between databases. Use a new connection to connect to a different database.
Msg 2812, Level 16, State 62, Line 6
Could not find stored procedure 'Execute Stored_Procedure_name'.