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.