If you ever did anything in SQL worth embedding into transaction(s), you were bound to encounter an age old problem of auditing failures in audit table(s) while at the same time rolling back the failed transaction. Problem ofcourse being that transaction rollbacks are efficient and blind in their duty and will leave no stone unturned while wiping out all evidence that your statements were ever executed on that server, this unfortunately including the inserts in the audit table. Kind of a catch 22 situation. Or was that the "chicken and the egg" dillema?
More...
87580fba-37fe-4fe7-ab0e-6d90c73db8f2|2|4.0
Tags: transaction, audit, sql, 2008, transaction, audit, sql, 2008, 2005, audit, sql, 2008, 2005, audit, sql, transaction, 2005, audit, sql, transaction, sql, audit, transaction, transaction, sql, audit, transaction, 2008, clr, audit, transaction, 2008, clr, audit, transaction, 2008, clr, audit, 2008, sql, clr, audit, transaction, sql, clr, audit, transaction, sql, clr, audit, transaction, sql, c#, audit, 2008, sql, c#, audit, transaction, sql, c#, audit, c#, sql, 2008, audit, c#, sql, transaction, audit, c#, 2005, 2008, sql, audit, 2005, transaction, sql, audit, 2005, transaction, sql, audit, transaction, clr, transaction, audit, sql, transaction, transaction, 2008, sql, transaction, 2005, 2008, sql, clr, 2005, clr, sql, audit, 2005, transaction, sql, clr, sql, audit, transaction, audit, sql, clr, transaction, audit, clr, clr, transaction, audit, clr, transaction, transaction, clr, audit, 2008, audit, clr, c#, transaction, audit, clr, clr, transaction, clr, clr, audit, transaction, clr, c#, audit, 2008, c#, c#, audit, clr, transaction, audit, c#, c#, c#, audit, 2008, c#, c#, audit, transaction, clr, c#, 2005, 2008, 2005, audit, clr, transaction, 2005, audit, clr, transaction, transaction, audit, c#, clr, transaction, audit, clr, transaction, transaction, 2008, c#, transaction, 2005, 2008, clr, clr, 2005, clr, 2005, audit, 2005, transaction, clr, clr, transaction, audit, clr, audit, 2005, clr, transaction, audit, clr, clr, transaction, audit, transaction, transaction, 2005, audit, 2005, audit, 2008, c#, transaction, audit, 2005, clr, transaction, clr, 2005, audit, transaction, clr, 2005, audit, 2008, c#, 2005, audit, transaction, clr, 2005, audit, 2008, c#, 2005, audit, transaction, c#, 2005, audit, 2008, clr, 2005, 2005, transaction, 2005, 2008, clr, transaction, 2005, 2005, clr, clr, transaction, 2005, c#, transaction, transaction, 2005, clr, 2008, transaction, transaction, c#, 2005, 2005, 2008, clr, 2008, 2005, clr, 2005, 2008, 2005, clr, clr, 2008, transaction, 2005, clr, transaction, 2005, 2005, transaction, clr, clr, 2008, transaction, clr, transaction, 2008, 2005, clr, 2005, 2008, 2008, transaction, transaction, c#, 2005, 2008, transaction, clr, 2005, 2008, transaction, clr, 2005, 2008, 2008, clr, 2005, 2008, transaction, c#, 2005, 2008, 2008, clr, 2005, 2008, transaction, c#, 2005, 2008, 2008, c#, 2005, 2008, transaction, clr, 2008, clr, transaction, c#, 2005, clr, clr, 2008, 2005, c#, transaction, c#, 2005, clr, 2008, 2008, transaction, c#, 2005, 2008, 2008, clr, 2008, c#, clr, 2005, 2008, c#, clr, clr, 2008, c#, 2005, clr, transaction, c#, 2005, 2005, clr, c#, 2008, clr, clr, c#, 2008, 2005, clr, c#, 2008, transaction, 2005, c#, c#, 2008, c#, clr, 2005, 2008, c#, clr, 2005, 2008, c#, clr, 2005, 2008, c#, c#, 2005, 2008, c#, clr, 2005, 2008, c#, c#, 2005, 2008, c#, c#, c#, 2008, 2005, clr, 2005, clr, 2008, c#, 2005, clr, 2005, 2008, 2005, c#, 2005, c#, 2008, clr, 2008, 2008, 2008, c#, 2005, 2008, 2005, clr, 2008, c#, 2008, 2008, 2005, 2008, c#, 2008, clr, 2008, c#, 2008, clr, 2008, c#, 2008, 2005, 2008, c#, 2008, clr, c#, c#, 2008, 2005, c#, c#, 2008, 2005, 2008, c#, c#, c#, c#, 2005, c#, c#, c#, 2005, c#, c#, c#, 2005, c#, c#, c#, 2005, c#, c#, c#, 2005, c#, c#, c#, 2005, c#, c#, c#, c#, c#, 2005, c#, 2005, 2008, 2005, 2005, 2005, 2005, 2008, 2008, 2008, 2005, 2005, 2008, 2008, 2008, 2008, 2008, 2008, 2008, 2008, 2008, 2008, 2008, c#, 2008, c#, 2008, 2008, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#, c#
SQL Server | SQL Server | SQL Server | C# | SQL Server | C# | SQL Server | C# | SQL Server | C# | SQL Server | SQL Server | SQL Server | C# | SQL Server | C# | SQL Server | C# | SQL Server | C# | SQL Server | C# | SQL Server | SQL Server | SQL Server | Programming | SQL Server | Programming | C# | C# | C# | Programming | SQL Server | C# | C# | Programming | SQL Server | C# | C# | C# | Programming | SQL Server | C# | C# | Programming | C# | C# | C# | Programming | C# | C# | C# | Programming | C# | C# | Programming | C# | C# | C# | Programming | C# | C# | C# | Programming | C# | C# | C# | Programming | C# | C# | Programming | C# | Programming | C# | Programming | Programming | Programming | Programming | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | SQL Server | C# | C# | SQL Server | C# | SQL Server | C# | C# | SQL Server | C# | C# | C# | C# | C# | C# | C# | C# | C# | C# | C# | C# | C#