When creating a local temporary table with say CREATE TABLE #MyTable, this should be accessible to all further calls in the same scope. Right?
What if the transaction is initiated through a c# application using the transaction scope object and not the standard SQL transaction? I cant seem to get this working.