In method1 I call a SP and catch any exceptions which I want to log and commit
So within the catch part of another try..catch within method1 I have the following code.
catch (Exception ex)
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
Conx.InsertLog( ex.Message, ex.StackTrace);
I understood that the second transactionscope should be unaffected by the ambient transcationscope...and when I step through the code errors are being logged. However they all seem to be rolled back by the ambient TransactionScope. What am I doing wrong??
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…