• Unless you're an Application Server Host, why would you ever need multipl versions of the same data out there?

    Now - if you ARE an application server host, and you need to track what logical version of the DB you're running for a particular customer...maybe, but i'd think this is one of the uglier ways to track that info.

    Sorry - I'm failing to see what value this would provide you (or anyone). That would mean that every time you increment versions, you'd have to update the version numbers. If you leave the older version online, you run the risk of "missing someone" and having them update the wrong database; if you don't then you run the risk of locking someone out for a while for no compelling reason. Never mind all of the jobs/references to that database that might need updating....

    Sounds like a lot of heartache for something that could be tracked a WHOLE lot more cleanly elsewhere.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?