CODEWITHSUNDEEP
sql-servert-sqlazureazure-sql-database
dsb
dsb

Reputation: 2517

Can not modify stored procedure on Azure

I'm new to Azure SQL database. I managed to migrate my database to the cloud.

Now I'm trying to modify a stored procedure using Microsoft SQL Server Management Studio (the latest edition - 2014). But get the following error message:

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

Any idea how can I do this? Also, is there any alternatives to Microsoft SQL Server Management Studio to work with Azure SQL Database?

Upvotes: 1

Views: 3512

Answers (1)

user844705
user844705

Reputation:

USE in sql is used to switch between databases not to modify stored procedures. You cannot use USE on Azure SQL as per the specification. You should be able to right-click on the database name in Microsoft SQL Server Management Studio (SSMS) and select New Query, or you can use the dropdown list in the menu to switch databases. You can then use ALTER PROCEDURE (https://msdn.microsoft.com/en-GB/library/ms189762.aspx) to alter your procedure.

You can use Visual Studio as an alternative to SSMS but IMHO Visual Studio is not as productive. It doesnt matter which client you use though, because USE wont work in any of them.

Upvotes: 2

Related Questions