>See my blog on this topic
>
>
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/truncate-log-in-all-your-user-databases>
>>Did George explain WHY tempdb is not skipped?
>
>BTW, I think the correct solution would be to query the current DB recovery model and restore it at the end. I'll research on this later.
Sure :-)
That is the correct behavior.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.