Depending on what your recovery model is, you may not be able to truncate any data from the transaction log until a transaction log backup has been run. What is your recovery model?
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455