remember you can use tempdb as a nearly normal database**

I create Structure for XML explict table and error_log table in tempdb and JOB-Agent bcp's these to files.xml

Their STRUCTURES/Programmes are copied into model

Every time SQL-2005 is restarted empty tables are created in tempdb,from model, and are then populated as required.

this data is available if error is found and correction to 'Standard' database table can be made - otherwise I am not sad to loose-data on sql_shutdown! We have to many tables in standard named as xtemp****** but nobody remembers what they were for!

**An article on differences between Tempdb/Model and 'STANDARD' sql-tables is probably some-where, it is just that I have been doing it this way for ages!