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::JoinTransaction returned 0x8004d00a].
LVL 5
volkingAsked:
Who is Participating?
 
Mr_PeerapolConnect With a Mentor Commented:
Hi volking,

Look at this http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

Hope it helps,
0
 
volkingAuthor Commented:
Excellent. That fixed our problem. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.