Feature Request for Format

Bill_Ross

I recently discovered that Microsoft Sql Server will allow you to create a stored procedure, view, etc, with nested comments, but, once created, will not allow you to retrieve it. For example:


/*
One comment

/*
Nested Comment
/*

End of first comment

*/

Create Proc myproc...


This can result in loss of countless hours of programming.

Can you add a feature to the formatting to flag nested comments?

chriskelly

Thank you for your suggestion.

I have lodged this with our development team as an Enhancement Request, reference: SP-3605.

simon.jackson

Bill, It may be worth noting that SQL Prompt will allow you to recover those scripts. In version 4 you can hover over the object name and click the yellow tooltip. The script pane will come up with the complete script.

If you are using the SQL Prompt 5 EAP you can right click on the object name and "Script object as alter", which avoids hitting this (and several other) bugs in SSMS's script object as alter.