Not sure that someone wants to think about work after 12-14 hours spend in office, but with an iPad one could be home after 8 hours and willing to take...

sorry it sholud be

set nocount on

and

set nocount off

Hi

Try this

set noconut on

delete from t2

set noconut off

if @@error <> 0

begin

rollback tran

set noconut off

end --if

return