In my opinion the problem is given by the ROLLBACK TRANS statement that cause batch to stop immediately,( if you comment the statement you can see what you probably want).  ...