Corgi,
I have since learned that if you kill the SPID (not the job), then the SPID will stop the job on its own and rollback. It may take a while, but it works.
If you kill the job, though, all bets are off.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.