try to find out in this way
BEGIN TRY --Start the Try Block..
BEGIN TRANSACTION -- Start the transaction..
UPDATE MyCurrentAccount SET Amount = Amount - 1000
WHERE AccountId = 004
UPDATE MySavings SET Amount = Amount + 'sssdgsggs'
WHERE AccountId = 004
COMMIT TRAN -- Transaction Success!
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRAN --RollBack in case of Error
END CATCH
Create table MyCurrentAccount(AccountId int,Amount int)
Create table MySavings (AccountId int,Amount int)
select * from MyCurrentAccount
select * from MySavings
insert into MySavings values(004,50000)