Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-02 : 09:08:40
|
Rajasekhar writes "Hi
I have a procedure and it executes a procedure on another server and returns the results to the calling procedure and dumps it into a temp table..
I have linked server setup and working. I have the proper permissions also.
But I get the following message when I execute the calling procedure:
-----
Server: Msg 7391, Level 16, State 1, Procedure proc1, Line 60
The operation could not be performed because the OLE DB provider 'SQLOLEDB' does not support distributed transactions.
[OLE/DB provider returned message: Distributed transaction error]
----
But both the servers are running the distributed transaction corordinator
example:
create procedure dbo.proc1
@param1 int
as
create table #temp
(col1 int
col2 varchar(255)
)
insert into #temp
EXEC server.database.dbo.proc2 @param1 = @param1
go" |
|
|
Xnera
Starting Member
1 Post |
Posted - 2003-02-21 : 12:40:19
|
| I get this same error - but only sometimes. I can't figure out exactly why it occurs and why sometimes it does not. My best guess is it happens after I just tryed something via the linked server that failed.We have all the proper permissions and ports open as well.So I was going to try 'SET XACT_ABORT OFF', but I am not sure where to put it. Do I have to set that on the linked server? If so, how do I do that call from my local server? I can't change the linked servers sprocs as they are third party. |
 |
|
|
|
|
|
Stored Procedure calling another stored procedure