Provides intelligent code completion for SQL Server editors.
Moderators: David Atkinson, Anu Deshpande, Luke Jefferson
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:
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 6:49 pm
Thank you for your suggestion.
I have lodged this with our development team as an Enhancement Request, reference: SP-3605.
- Posts: 330
- Joined: Mon Apr 19, 2010 1:44 pm
- Location: Cambridge, UK
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 10:42 am
Return to SQL Prompt Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests