Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). Enhance Your Transaction Flexibility With Embedded Stored Procedures   Article Abstract: (Ben Taylor) This article explains about transactions and how you can use stored procedures, called from within the transactions, to add a bit of transactional processing around your procedures.   Read this article...

Related Articles - For Members. All Articles By Author SQL Server 2005 XML Optimization Tips Stored Procedures Administration Tips for using SQL Server 2005 stored procedures Transactions and Locks in SQL Server Optimizing Stored Procedures To Avoid Recompiles Transactional Meditation: T-SQL Commitment Conrol Automate Query Development With Templates Introduction to XML

RE: Enhance Your Transaction Flexibility With Embedded Stored Procedures
(posted: 6/3/2005 9:49:46 AM)
> "I decided to break these portions of code into separate stored procedures and to call them from different stored procedures that would implement the desired transactions. This article demonstrates how to enforce transactions in a way that is readable and predictable by calling a stored procedure from within a parent stored procedure." -- The article describes a good example of implementing "helper" stored procedures (and some of the benefits of doing so). HTH SM