Solved

sp_refreshview error on linked server

Posted on 2006-07-07
2
633 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
ID: 17058857
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
ID: 17061836
Excellent. That fixed our problem. Thanks.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

840 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