>>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.

Found this http://blog.sqlauthority.com/2009/07/16/sql-server-four-different-ways-to-find-recovery-model-for-database/

may look later on introducing that logic into the blog