SQL Module metadata

A look at the meta-data contained by SQL Server for programmable modules, and some background information on how it can be rendered incorrect by sp_rename, as well as how you can use the meta-data to look at the source for internal SQL Server procedures