• I have an idea that with SQL Server 2005 you could accomplish something like this using a database snapshot.

    Has anybody actually tried that?