Original VB.NET and C# article.
The VB.NET Version will be available shortly, code was been rewritten (resides here) just need time to write the TechNet article.
Calling Stored Procedures Using Transact-SQL
Using XML Serialization with C# and SQL Server
T-SQL : Search for string or phrase in SQL Server database
SQL Server: Searching All Columns in a Table for a String
SQL: Protect Your Data against SQL Injection
SSMS: Generate Scripts for Stored Procedures Without Dynamic SQL
T-SQL: Script to Find the Names of Stored Procedures that Use Dynamic SQL
SQL Server Result Set In An HTML Email
SQL Server: Stored procedure to add row-level auditing to table