sbateman (7/17/2008)
remember you can use tempdb as a nearly normal database**I create Structure for XML explict table
and error_log tablein tempdb and JOB-Agent bcp's these to files.xmlTheir 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!
Hmmm that makes sense... Grab the data out of tempdb...