• SanDroid (4/7/2011)


    Stefan Krzywicki (4/7/2011)


    Please forgive my misstatement and allow me to rephrase

    As you're questioning the statements in the QOTD and others have posted links to articles supporting the conclusion you should post something supporting what you're stating otherwise no-one has any reason to accept your statements.

    Stefan - Nobody has responded with an article that states exactly what was todays answer. That includes both of your posts. That includes the hour I spent looking for one before my first post.

    I have understood since before today that "operations against the version store" are not logged.

    Today I want to understand and learn about how "data affecting the version store" is not logged.

    It is a very thought provoking question Wayne has created and I like it very much becuase it puts to bed a lot of SQL Logging "Myth's".

    My two favorites having always been "Truncat Table is not logged" and "Temp Tables are not logged"

    So to clarify your position, because you don't think anyone else has shown evidence that convinces you the QOTD is correct, you don't feel the need to show evidence for what you "see every day". Even though if you see it every day it must be pretty easy to obtain such evidence or tell other people how they can see it?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams