Visual studio feeds

All Visual Studio blogs in one place


Enter your email address:

Delivered by FeedBurner

Increase your website traffic with



Anti-spam: How many eyes has a typical person?

Follow us on FB


Preserving format of procedure when using sp_helptext

AddThis Social Bookmark Button
Often peple ask this question in the forum. "I created a procedure with proper alignment. But when I wanted to alter the procedure, result of sp_helptext did not keep the original alignment. How do I keep the original format?" Well. One answer is to make use of Script Stored Procedure --> ALTER TO option from Management Studio. If you want to use sp_helptext system procedure to view and alter, set the result mode of the query window to Text (Press CTRL+T). The text result mode will keep the original alignment Consider this simple procedure create procedure test as select name,create_date from sys.objects Now set the result
mode to Text and run this EXEC sp_helptext test The result will have the origninal formatting with proper alignment. So you need to aware of this when using sp_helptext system proceudre
...(Read whole news on source site)

Home : Blog List : Madhivanan's TSQL Blog : Preserving format of procedure when using sp_helptext