Home Forums SQL Server 2005 SQL Server 2005 General Discussion OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active." RE: OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active."
Mohan Kumar
SSCertifiable
Points: 5365
More actions
May 27, 2010 at 5:57 pm
#1173660
I am sure you might have resolved issue by now but just in case Not resolved then you may refer link
http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp
that can guide you resolve this issue even for Windows Server 2008.
[font="Verdana"]--www.sqlvillage.com[/size][/font]