I have a stored procedure that runs nightly.  It truncates the log and also shrinks the database.  It is as follows:

/*----------------------------------------------

   Truncates Transaction Log and Shrinks DB   

   Scheduled to run...