On page 214 in the C# edition, they show code for the sp_News_UpdateNews stored procedure, and make a point of using a transaction "so that the changes can be rolled back." But, they only have a single update statement, and isn't that atomic by itself? Why is the transaction necessary?