I would also vote for XML formatting to be reviewed in future versions.
Taking the Books OnLine example from http://msdn.microsoft.com/en-us/library/ms186918.aspx the WITH block from example B gets treated as a single line rather than as a column list when formatted by SQL Prompt + SQL Refactor
Comments
Unfortunately SQL Prompt v4 does not yet support CLR types (including xml) and so it fails to prompt suggestions.
I have logged this as a feature request in our internal tracking system whose id is SP-2866.
Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Taking the Books OnLine example from http://msdn.microsoft.com/en-us/library/ms186918.aspx the WITH block from example B gets treated as a single line rather than as a column list when formatted by SQL Prompt + SQL Refactor
Senior DBA
Careers South West Ltd