Truncate transaction log and free up unused database space

Code for a stored procedure that can be used to truncate transaction logs and free unused space from all user databases. It is best used when part of a maintenance plain in SQL Server 2005 or scheduled job in SQL Server 2000.