Here is what I used:

it may be worth running a checkpoint command / backup prior to running this so sql know the transaction log can be reduced

-- Truncate the log...

before you go rushing into ClickView - there is one key point I think I should make.............

almost all roads lead to Excel...... :w00t:

think I may a resolved it