>>>truncate it or shrink it...
>
>Here's a very quick and very dirty way to truncate the log.
>In database properties/option change recovery model to simple.
>From the context menu select All Tasks/Shink Database.
>Definitely not the text book way, but it's gotten me out of a few scrapes when the log file had become huge.
>>That worked...the part I was missing changing the recovery model....
>>Thanks!
Glad it helped.
If you want to take advantage of the log in the future, change the reoovery model back to full and put in a backup procedure that will take care of shrinking the log for you.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.