Hi,
We are getting the following error when our users try to
generate a report- that makes a call to a DLL whose
function calls a stored procedure to retrieve the results.
The DLL is a componenet registered with MTS and called at
the end of a trigger in a MSMQ

Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Distributed
transaction completed. Either enlist this session in a new
transaction or the NULL transaction.

Could anyone please suggest the causes??

Thanks
--Aarthi

try googling

http://tinyurl.com/2n4ut

How does this relate to DTS?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Aarthi RS" <aarhi.saravanakumar (AT) corporate (DOT) ge.com> wrote