Sorry to resurrect this old thread, but I"m in the middle of a project to upgrade our sql 2000 dbs to sql 2008. I'd like to also use this as an opportunity to get rid of any procedures that aren't being used.
For the most part, I like the solution. I'm curious to hear everyone's input though about the frequency he ran the update code. Every 15 minutes? Ouch! Can somoene explain to me why this couldn't just as easily be run every hour or every 3 or 4 hours. If I were to run that code on my dbs every 15 minutes for a month, and have a whole other issue to contend with!
There is no harm to output to stand along table with identity column primary key in another database every 15 minute.
Even it will be millions of rows identity will always pack the rows and place it at the end of the page. I did it for 2 months and run solution every 2-3 minutes without any issues.