Bug: Scripts for objects with extended properties full of garbage
When adding an extended property to any table that contains non-varchar or -nvarchar extended properties, three lines of junk code are added to the bottom of the object script file for each of those extended properties (declaring a variable, setting that variable with a select, and a GO).
I believe that this may be related to an issue in the Compare engine that I already opened here https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/39729406-more-efficient-scripting-for-non-varchar-nvarchar — it's really beginning to seem like Compare and Source Control aren't usable unless your database modelling follows the pattern that Redgate expects. I don't think it should be that way round :|