volking
asked on
sp_refreshview error on linked server
I have 2 SQL servers: myDEV and myTRN
I have a VIEW on myDEV pointing to myTRN, like this ...
Use myDEV
CREATE VIEW dbo.myRpt AS SELECT * FROM myTRN.JJR.dbo.myRpt
The view is created and it Works fine.
However, later, I try ...
exec sp_refreshview myRpt
I get Error ....
Server: Msg 7391, Level 16, State 1, Procedure myRpt, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTran
I have a VIEW on myDEV pointing to myTRN, like this ...
Use myDEV
CREATE VIEW dbo.myRpt AS SELECT * FROM myTRN.JJR.dbo.myRpt
The view is created and it Works fine.
However, later, I try ...
exec sp_refreshview myRpt
I get Error ....
Server: Msg 7391, Level 16, State 1, Procedure myRpt, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTran
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER