sp_helptext in SQL Server 2014

sp_helptext in SQL Server is one of my favorite system stored procedure. It displays the definition of unencrypted objects like stored procedures, functions, triggers, computed columns, views etc. Interestingly there is also an object called sp_helptext in Sybase system. It is a rumor that this sp was first developed by Sybase system when Microsoft and Sybase had an alliance in mid 80’s. Anyways, I found a very interesting thing, while copying the result set of sp_helptext to a new query window from SQL Server 2014. In earlier versions of SQL Server we used to switch to the text mode (ctrl + t) to get the object definition with proper indents and actual format, but in SQL Server 2014 you can get the object definitions with proper indents and format in default grid mode without switching over to the text mode.

sp_helptext-sql-server-2012

sp_helptext-sql-server-2014

 

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

Leave a Reply

%d bloggers like this: