How can we help you today? How can we help you today?

Feature Request for Format

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?
Bill_Ross
0

Comments

2 comments

Sort by
  • chriskelly
    Thank you for your suggestion.

    I have lodged this with our development team as an Enhancement Request, reference: SP-3605.
    chriskelly
    0
  • 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.
    simon.jackson
    0

Add comment

Please sign in to leave a comment.