• Ahan , so that's why it did not go the way I thought. SSMS entire query is getting rolled back