Overhead using SDAC to access SQL

Frenk3 · Post by **Frenk3** » Tue 03 Apr 2007 15:44

I was testing protocol overhead using SQL Profiler vs QueryAnalyzer. What part of SDAC can I use to get rid of all the overhead that becomes form using high level componets?

The bigest problem is when using sp_bindsession. SDAC automatically calls COMMIT/ROLLBACK TRAN (and forces binding transaction to be completed, what I don't want to be done). How can I force SDAC not to call anything without explicitly saying (e.g. using native SQL)

Regards,
Frenk

Frenk3 · Post by **Frenk3** » Wed 04 Apr 2007 01:27

for transaction rollback, it was SET XACT_ABORT "fault". So it wasn't SDACs fault. Problem is solved now. Sorry for a mess.
Rgds,
Frenk