Timeline for Forcing MS SQL Server to rollback on error
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 17, 2016 at 23:42 | answer | added | Jamie Alford | timeline score: 1 | |
| Oct 29, 2015 at 16:20 | comment | added | Pixelated | Testing it without the separate batches and with a SELECT 1/0 does cause it to fail as expected. | |
| Oct 29, 2015 at 16:06 | comment | added | datagod | Try removing the GO statements within the transaction. | |
| Oct 29, 2015 at 9:37 | answer | added | Julien Vavasseur | timeline score: 2 | |
| Oct 29, 2015 at 7:43 | comment | added | Mark Sinkinson |
There doesn't appear to be a ROLLBACK TRANSACTION in your script. Is this a deliberate omission?
|
|
| Oct 29, 2015 at 7:39 | history | asked | vwrynn | CC BY-SA 3.0 |