Thanks mate for that comment. It, helped me out.

What is annoying me is that on MSDN examples, the BEGIN TRANSACTION statement is outside the TRY..CATCH block...