All versions of SQL Server have had some stored procedures that are not documented in MSDN. The fact that they are not documented indicates that Microsoft has those stored procedures for its internal use only and does not intends or recommends them to be used in Production code by SQL Server customers. The undocumented stored procedures can be deprecated or modified without any notice.

It is strongly recommended to avoid using undocumented features of SQL Server in your Production environment.

Having said that, many of the undocumented stored procedures can be quite handy for day-to-day adhoc stuff. The following articles list out many of those stored procedures, some with examples.

List of Undocumented Stored Procedures in SQL Server

Undocumented Extended and Stored Procedures

Useful undocumented extended stored procedures

SQL Server 2000 useful undocumented stored procedures

Useful Undocumented SQL Server 2005 Extended Stored Procedures

SQL Server Programming Hacks - 100+ List : Undocumented but handy

SQL Server Undocumented Stored Procedures sp_MSforeachtable and sp_MSforeachdb
Discusses how to use these and comparison with using cursors

Take advantage of undocumented SQL Server iteration procedures
Basic usage of the two undocumented stored procedures.