In my application I am having ADO and ADO.NET connection, I need to use sp_bingsession to rollback and commit transations. SQL Azure does not support sp_bindsession and sp_getbindtoken. So what is alternative to this? How can I achieve the sa

Hi,

I'm facing a different situation using sp_getbindtoken.

Currently we are using sp_getbindtoken as part of an Audit trail implementation for a couple of tables. An initial SP within the transaction inserts the "transaction-id" into a AuditTrailChangeSet-table. Trigger code later adds that same transaction-id to all Audit tables in order to bind them to a specific Change Set.

Some ideas how to get this working:
1) Extra column on all live tables
We could add an extra GUID-column to all live tables we like to audit, keeping the last AuditChangeSet-Id
Just a gut feeling, I rather not. It would also add data and bandwidth

2) Envers
We have been looking into to this solution: http://www.nuget.org/List/Packages/NHibernate.Envers
But that would add other 100% overhead in RTT for all inserts => ~50 ms/insert for SQL Azure

Does onyone have another idea how to achieve the same, without using sp_getbindtoken?