SET XACT_ABORT ON : Açıkken Try Catch arasındaki ve buna bağlı olan diğer tüm transactionlar rollback olurlar. SET XACT_ABORT OFF: Kapalıyken sadece TRY..CATCH arasındaki transaction rollback olur,buna bağlı olan diğer tüm transactionlar işlemi success ile bitiriler. BİZZAT BİRBİRNE BAĞLANTILI içiçe stored procedurelar için de denedim, kesinlikle ikinci stored procedure da etki eidyor. rollback yapıyor. http://technet.microsoft.com/en-us/library/ms188792.aspx When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back. When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing. Depending upon the severity of the error, the entire transaction may be rolled back even when SET XACT_ABORT is OFF. OFF is the default setting. Compile errors, such as syntax errors, are not affected by SET XACT_ABORT. XACT_ABORT must be set ON for data modification statements in an implicit or explicit transaction against most OLE DB providers, including SQL Server. The only case where this option is not required is if the provider supports nested transactions. The setting of SET XACT_ABORT is set at execute or run time and not at parse time.
