sp_helptext output loosing format of the code when displayed in grid...
To get and edit a stored procedure source code I use the sp_helptext which sends the output to result pane. If the result pane is in text mode the code that is printed is retaining the the original format with tabs and spaces etc.
But when the results pan is in grid mode (CTRL+D) and if I do select all rows and copy and paste the code into a new code window the code is loosing it's format. All the tabs are getting converted into a space.
Upvotes: 2<=-=Jul 9 2008 8:37AM=-=>
Thank you for the feedback. This feature will be tracked as a feature candidate of future release.
Program Manager, Microsoft SQL Server
We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.
Thanks for writing in to Microsoft.
Eagerly looking forward to the fix,