We use this exact strategy and it works great! Give it a go.

Added schema to tables

IF NOT EXISTS(SELECT NULL

FROM INFORMATION_SCHEMA.SCHEMATA

...

Given some of the limitations with Replication Monitoring, problems with stale subscriptions on large tables etc it's a solid approach.

Kudos Thanh -- nice article!

rja.carnegie (10/2/2009)

I assumed that was why you didn't jump on the "we got to the Moon...

"Apollo 1 is the official name that was retroactively assigned to the never-flown Apollo/Saturn 204 (AS-204) mission. Its command module (CM-012) was destroyed by fire during a test and training...

Phil Factor (10/1/2009)Are you sure? Ironically, the astronauts got to the moon thanks to Charles Moore's simple and lightweight Forth-based software. NASA used a lot of his applications. He...

The Waterfall approach: First hire an army of business analysts and project managers to full describe what will be built. Add some more people to do scheduling (Critical Path -style...

Neat gun collection too 🙂 I'd bet those surly developer types don't give you a lot of crap :w00t:

We've all been there: This is a classic problem and really could use more discussion. Thank you for taking the time to write this article and sharing your solution. Nice...

Using procmon for this is certainly a new twist on this--thanks!.