What's the difference between an SQL transaction at the stored procedure level and one at the SqlConnection level?
Say a stored procedure on MSSQL Server uses an SQL transaction using `BEGIN TRANSACTION/COMMIT TRANSACTION`, how does that differ from beginning and commiting one using ADO.NET via `SqlConnection.BeginTransaction()`?

What's the difference between an SQL transaction at the stored procedure level and one at the SqlConnection level?
===

Say a stored procedure on MSSQL Server uses an SQL transaction using `BEGIN TRANSACTION/COMMIT TRANSACTION`, how does that differ from beginning and commiting one using ADO.NET via `SqlConnection.BeginTransaction()`?
