SQL Server documenter script
I had to document a database recently. Nothing fancy, just a list of the objects (tables, indexes, stored procs). There are tools available to do that but the SQL server was very secured (and I applaud that) and all I could do was to run a script locally. A quick search lead me to this CodeProject article by Nitinpatel:
http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx
It’s basically just a T-SQL script that go thru all the objects in a database and generates an HTML output. Cool!