What are the challenges you face when working across database platforms? Take the survey
Options

Feature Request for Format

Bill_RossBill_Ross Posts: 20
edited November 30, 2010 6:54AM in SQL Prompt Previous Versions
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?

Comments

  • Options
    Thank you for your suggestion.

    I have lodged this with our development team as an Enhancement Request, reference: SP-3605.
  • Options
    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.
Sign In or Register to comment.