I got following error when i tried to run a procedure which has a
distributed tran in it:
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
does not support distributed transactions. [OLE/DB provider returned
message: Distributed transaction error]
both my local and linked server has DTC service running, sql7 with sp3
any idea why it still give me this error? Thanks!