Saw a mention of this in the latest MSDN Magazine, you can download Reflector.SQL2005Browser and install it as an add-in for the well know Reflector tool (both are free). Point it at a server, pick a database, and you can browse through the deployed CLR objects. From there you can pick a function and disassemble to the code of your choice. Defaults to C#, but does VB.Net as well. Probably not something we DBA's will use every day, but nice to have available when you do need it.