Does stopping query with a rollback guarantee a rollback <p>Say I have a query like this:</p> <pre><code>BEGIN Transaction UPDATE Person SET Field=1 Rollback </code></pre> <p>There are one hundred million people. I stopped the query after twenty minutes. Will SQL Server rollback the records updated?</p>