This works with MS SQL 2005 and 2008
Use <database Name> GO Alter Database <database Name> Set Recovery Simple GO Alter Database <database Name> Set Recovery Full GO DBCC SHRINKFILE (‘<log file name>’, 1) GO