SQL Server Solutions with Practical SQL DBA: MS SQL Server : Nested Transaction and Partial Rollback

SQL server will allow you to start transaction inside the transaction which is called as nested transaction . Nested transaction will allow to commit transaction individually but will not allow to rollback individual transactions.In fact nested transactio

www.practicalsqldba.com