I have just set up my first Azure database and am managing it using SSMS but have just noticed that the context menu item 'Script Stored Proc As \ Alter To..' is greyed out.

' \ Create To..' works fine as does executing an Alter statement.

So why is it greyed out?

An old thread of the same problem can be found here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d8fb9afe-42a6-4b3d-98f4-432d54feee4f/how-to-modify-stored-procedures-in-sql-azure-database-in-sql-server-express-2012?forum=ssdsgetstarted&prof=required

Hi,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue.

Regards,

Mekh.

Hi,

Apologies for the inconvenience.

I would request you to report it once again to https://connect.microsoft.com/sqlServer/feedback.

Regards,

Mekh.

• Proposed as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 03, 2014 6:56 AM
• Unproposed as answer by PhantomMan221 Wednesday, December 03, 2014 12:08 PM

Hi,

Apologies for the inconvenience.

I would request you to report it once again to https://connect.microsoft.com/sqlServer/feedback.

Regards,

Mekh.

• Proposed as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 03, 2014 6:56 AM
• Unproposed as answer by PhantomMan221 Wednesday, December 03, 2014 12:08 PM

Hi,

Apologies for the inconvenience.

I would request you to report it once again to https://connect.microsoft.com/sqlServer/feedback.

Regards,

Mekh.

• Proposed as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 03, 2014 6:56 AM
• Unproposed as answer by PhantomMan221 Wednesday, December 03, 2014 12:08 PM

I have just set up my first Azure database and am managing it using SSMS but have just noticed that the context menu item 'Script Stored Proc As \ Alter To..' is greyed out.

' \ Create To..' works fine as does executing an Alter statement.

So why is it greyed out?

An old thread of the same problem can be found here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d8fb9afe-42a6-4b3d-98f4-432d54feee4f/how-to-modify-stored-procedures-in-sql-azure-database-in-sql-server-express-2012?forum=ssdsgetstarted&prof=required

• Merged by Shirisha PaderuMicrosoft contingent staff, Moderator Wednesday, December 03, 2014 3:57 PM Same query from the same person

I have just set up my first Azure database and am managing it using SSMS but have just noticed that the context menu item 'Script Stored Proc As \ Alter To..' is greyed out.

' \ Create To..' works fine as does executing an Alter statement.

So why is it greyed out?

An old thread of the same problem can be found here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d8fb9afe-42a6-4b3d-98f4-432d54feee4f/how-to-modify-stored-procedures-in-sql-azure-database-in-sql-server-express-2012?forum=ssdsgetstarted&prof=required

• Merged by Shirisha PaderuMicrosoft contingent staff, Moderator Wednesday, December 03, 2014 3:57 PM Same query from the same person

I have just set up my first Azure database and am managing it using SSMS but have just noticed that the context menu item 'Script Stored Proc As \ Alter To..' is greyed out.

' \ Create To..' works fine as does executing an Alter statement.

So why is it greyed out?

An old thread of the same problem can be found here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d8fb9afe-42a6-4b3d-98f4-432d54feee4f/how-to-modify-stored-procedures-in-sql-azure-database-in-sql-server-express-2012?forum=ssdsgetstarted&prof=required

• Merged by Shirisha PaderuMicrosoft contingent staff, Moderator Wednesday, December 03, 2014 3:57 PM Same query from the same person

Ok I have re submitted the same question to the same place.  But Why ?

Hi,

Thank you for submitting the feedback. It is the channel through which the relevant team will work on the issue.

You can try the below in the meantime.

1. Are you able to perform the same option in the Azure Management Portal? If yes, I would request you to use the management portal.
2. Please use the latest verison of SSMS and check.
3. Run the SSMS as Run as administrator and check.

Regards,

Mekh.

Hi,

Any updates on the issue ?

Regards,

Mekh.

Hi

In response to your suggestions:

1) How can I access stored procedures through the azure web portal?

2) I am using the latest version 11.0.3000.0

3) Tried running as admin and same problem

As I mentioned in my original post, it looks like this problem has been around for 2 years so there must have been a bug report about it at some time in the past.  Is there no progress on this ?

Please can you escalate.

Thanks

Hi,

Please have a check on the below link which talks about ALTER PROCEDURE (Transact-SQL).

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

http://msdn.microsoft.com/en-us/library/ms189762.aspx

Regards,

Mekh.

Thanks but that doesn't help with the original problem of Modify option missingg on the context menu and Alter being greyed out (among many others)

Hi,

The reason is CREATE/ALTER PROCEDURE is a Partially Supported Feature in SQL Database.

SQL Database Transact-SQL statements support some but not all of the arguments that exist in the corresponding SQL Server Transact-SQL statements.

Reference : http://msdn.microsoft.com/en-us/library/azure/ee336281.aspx#PartSupport

Regards,

Mekh.

• Proposed as answer by Mekh SubbaMicrosoft contingent staff, Moderator Thursday, December 11, 2014 5:47 AM

Hi,

The reason is CREATE/ALTER PROCEDURE is a Partially Supported Feature in SQL Database.

SQL Database Transact-SQL statements support some but not all of the arguments that exist in the corresponding SQL Server Transact-SQL statements.

Reference : http://msdn.microsoft.com/en-us/library/azure/ee336281.aspx#PartSupport

Regards,

Mekh.

• Proposed as answer by Mekh SubbaMicrosoft contingent staff, Moderator Thursday, December 11, 2014 5:47 AM

Hi,

The reason is CREATE/ALTER PROCEDURE is a Partially Supported Feature in SQL Database.

SQL Database Transact-SQL statements support some but not all of the arguments that exist in the corresponding SQL Server Transact-SQL statements.

Reference : http://msdn.microsoft.com/en-us/library/azure/ee336281.aspx#PartSupport

Regards,

Mekh.

• Proposed as answer by Mekh SubbaMicrosoft contingent staff, Moderator Thursday, December 11, 2014 5:47 AM

CREATE PROCEDURE is also different in Azure but this function works fine.

What then is the recommended way to alter a stored procedure?

If the answer is to Script it using Create then change the word Create to Alter, why can't SSMS do that ?

When using Script as Alter on standard databases, the resulting SQL generated is the same as what's needed in Azure.

It makes no sense

Hi,

Apologies for the inconvenience.

"ALTER To" through SSMS is not supported in Azure SQL Database. The recommended way is though script.

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Tuesday, December 16, 2014 10:20 AM .
• Marked as answer by Lakshmeesha PhaneeshaMicrosoft contingent staff, Moderator Thursday, December 18, 2014 6:47 AM

Hi,

Apologies for the inconvenience.

"ALTER To" through SSMS is not supported in Azure SQL Database. The recommended way is though script.

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Tuesday, December 16, 2014 10:20 AM .
• Marked as answer by Lakshmeesha PhaneeshaMicrosoft contingent staff, Moderator Thursday, December 18, 2014 6:47 AM

Hi,

Apologies for the inconvenience.

"ALTER To" through SSMS is not supported in Azure SQL Database. The recommended way is though script.

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Tuesday, December 16, 2014 10:20 AM .
• Marked as answer by Lakshmeesha PhaneeshaMicrosoft contingent staff, Moderator Thursday, December 18, 2014 6:47 AM

I agree it is frustrating.  My solution is just to script as DROP and CREATE (does the same thing, just don't mess up) ;-)