Solved

sp_refreshview error on linked server

Posted on 2006-07-07
2
630 Views
Last Modified: 2007-12-19
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].
0
Comment
Question by:volking
2 Comments
 
LVL 25

Accepted Solution

by:
Mr_Peerapol earned 500 total points
Comment Utility
Hi volking,

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

Hope it helps,
0
 
LVL 5

Author Comment

by:volking
Comment Utility
Excellent. That fixed our problem. Thanks.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now