Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SQL Management Studio strips stored procedure comments when connecting with Column Encryption Setting Enabled

When connecting to SQL Azure using the "Column Encryption Setting = Enabled" connection setting (in order to use Always Encrypted), any ALTER PROC statement strips comments and reformats the submitted SQL when saving the SP. When connecting to the same database WITHOUT that connection setting, stored procs can be saved as expected, including comments and user formatting.

10 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Mike commented  ·   ·  Flag as inappropriate

    This problem is a disaster! It's completely unacceptable for a pre-processor to permanently strip out comments, newlines, and change the physical layout of code in stored procedures! It has been a major issue for us and has already led to unrecoverable loss of logic that was temporarily commented during diagnostics. It amazes me that this has somehow gone uncorrected for nearly a year now. FIX IT.

Feedback and Knowledge Base