Whitespace in parameter values when combined with annotations
It seems I can either specify design-time values for parameters or I can use annotations. If I try to use both, the parameter value is surrounded by white space. I even wrapped the parameter value in <![CDATA[ ]]> hoping the XML parser would normalize the white space between tags like it appears to with most other tags, but it does not. Occasionally if I strip all extra white space out of the parameter markup it will work, but that is far from ideal.
Is there any way to successfully combine parameter values with annotations? Aside from using descriptions, I was hoping to also add tags to some parameters so I could target them for a script to generate T-SQL calls to EXEC catalog.create_environment_variable.