• You can use the RAISERROR Statment with the NO WAIT option to achieve the behaviour you want.