Timeline for What events still occur within a transaction that gets rolled back?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 13, 2022 at 22:30 | comment | added | Charlieface | The LSN value goes up as well, and does not rollback. Not sure whether that's obvious though, considering what it represents. | |
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| Nov 18, 2019 at 14:58 | vote | accept | J.D. | ||
| Nov 18, 2019 at 5:50 | comment | added | Solomon Rutzky |
@DavidBrowne-Microsoft Thanks for pointing those out. I've gone ahead and added most of them, and added CONTEXT_INFO and OLE Automation procs. I didn't add the error log as that, while true, is outside of SQL Server (for the most part). I actually had originally planned on including SQLCLR and sp_OA*, can't remember why I didn't, but I added them now. Just FYI re: SQLCLR, by default regular connections did side-step transactions prior to SQL Server 2012, but SqlConnection default change in .NET 4.0/4.5 for enlist=true, so now you need to add false else it will enlist in the tran.
|
|
| Nov 18, 2019 at 5:04 | history | edited | Solomon Rutzky | CC BY-SA 4.0 |
added notes from David Browne, posted in a comment on this answer, and added CONTEXT_INFO and sp_OA* procs to that list
|
| Nov 17, 2019 at 21:50 | comment | added | David Browne - Microsoft | Also writing to the session_context, or the error log, and of course DML run inside a CLR proc not using the context_connection, or in an extended stored procedure. | |
| Nov 17, 2019 at 20:09 | comment | added | Solomon Rutzky |
@TiborKaraszi Thanks for mentioning that. I have added it as item #4 in my list. I confirmed that sequences did work that way (figured they did, but wanted to make sure). I also confirmed and added @@DBTS value to that edge-case list.
|
|
| Nov 17, 2019 at 20:07 | history | edited | Solomon Rutzky | CC BY-SA 4.0 |
added note from Tibor Karaszi, posted in a comment on this answer, and added @@DBTS to that list
|
| Nov 17, 2019 at 13:45 | comment | added | Tibor Karaszi | One could argue that an edge case is consuming an identity/sequence value. Does that modify data? I guess it depends on your viewpoint, level of abstraction etc. | |
| Nov 15, 2019 at 22:23 | history | edited | Solomon Rutzky | CC BY-SA 4.0 |
added example code
|
| Nov 15, 2019 at 21:35 | history | answered | Solomon Rutzky | CC BY-SA 4.0 |