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.
This is a duplicate of https://feedback.azure.com/admin/v3/suggestions/32895916/
Please, upvote that UserVoice item.
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.