Triggers and Batch Separators

Thomas Rushton has a warning for us:

Let’s test that script:

Create Table Trigger Fired
Completion time: 2021-02-27T14:17:09.4783931+00:00

Great. Refresh the tables list in the object explorer to go poking around, and:

Hmm. We have a problem.

Click through to understand what happened.