SQL Stored Procedure-Linked Server error

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL Stored Procedure-Linked Server error

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-17 : 08:51:14

Felix writes "Here is I am trying to do. I have a linked server named IHIST and I am trying to do a Stored Procedure to take data from the Linked Server (IHIST)and load a table call MainReport; However I get this error message. Here is the stored procedure that I have;

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO

CREATE PROCEDURE [insert_MainReport_1]
(@Tagname_1 [varchar](60),
@Description_2 [varchar](60),
@Value_3 [bigint],
@TimeStamp_4 [datetime])

AS

INSERT INTO [iHist].[dbo].[MainReport]
( [Tagname],
[Description],
[Value],
[TimeStamp])

SELECT * FROM OPENQUERY(IHIST,'SELECT T.TAGNAME, t.description, R.VALUE, r.timestamp
FROM ihTags t join inner ihrawdata r on t.tagname=r.tagname')

GO

GO

The error message is;
Error 7390: The requested operation could not be performed because the OLE DB provider does not support the required transactioninterface."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources