Nope, I think you're exactly right. When I left work, I started thinking it through, it just doesn't seem logical that it's something that you can do. I...

Thank you very much   I will check the BOL for more info.

For future reference, use the SET IMPLICIT_TRANSACTIONS ON statement when working in Query Analyzer.  This way you can use the "rollback" statement to reverse changes, or use the "commit" statement...