Feature Request for Format

Provides intelligent code completion for SQL Server editors.

Feature Request for Format

Postby Bill_Ross » Mon Nov 22, 2010 4:30 pm

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?
Posts: 14
Joined: Mon Mar 22, 2010 5:49 pm

Postby chriskelly » Tue Nov 23, 2010 5:55 pm

Thank you for your suggestion.

I have lodged this with our development team as an Enhancement Request, reference: SP-3605.
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Postby simon.jackson » Tue Nov 30, 2010 11:54 am

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.
Posts: 45
Joined: Thu Jan 08, 2009 9:42 am

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests