I think so.

If your requeriments and your business's logic allow it, it's better manage the transactions in the stored procedures inside SQL Server than manage from the client aplication.