I'm trying to get the [transaction metadata][1] working with debezium 1.4.1.Final using a SQL Server database.
It seems to be working to some extent - the `dbservername.transaction` topic has been created, and when I run a stored proc which contains a transaction, then the `"status":"BEGIN"` event is received, along with the CDC packets on the table topic.
However, no `"status":"END"` event is received... until I run the stored proc again.
It may very well be that I'm not closing the transaction in the stored proc correctly (I'm not a MSSQL expert by any means)...
This is the structure I'm using:
```sql
CREATE PROCEDURE schema.myproc
AS
BEGIN
BEGIN TRANSACTION
...
COMMIT;
END
GO
```
Any ideas what I need to do to get the `END` event at the end of the proc?