• Charles, one thing to watch out for. The new table you're talking about adding to the Model database would not only be added to tempdb on reboot, but it would also be added to any new database you create.

    Instead of adding something thing like that to tempdb you could consider a SQL server agent job that would recreate the table for you. This job could be set to run on startup.

    Just a thought.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]