Re: Executing INSERT INTO EXEC against linled server
From: Igor Marchenko (igormarchenko_at_hotmail.com)
Date: 02/02/05
- Next message: John Kane: "Re: SQL2000 5 times slower than SQL7 queries using LIKE '%SearchVa"
- Previous message: Steve Kass: "Re: Executing INSERT INTO EXEC against linled server"
- In reply to: Steve Kass: "Re: Executing INSERT INTO EXEC against linled server"
- Next in thread: oj: "Re: Executing INSERT INTO EXEC against linled server"
- Reply: oj: "Re: Executing INSERT INTO EXEC against linled server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Feb 2005 19:18:39 -0800
Hello Steve,
Computer I am querying from is using Windows XP SP2. Linked server running
Windows 2000. Both computers have SQL Server 2000 SP3 instralled. As I
mentioned, both computers run MS DTC. I am trying to collect list of the
databases and RECOVERY MODEL from linked server. The easiest way would be
executing sp_help and inserting output into temporary table on my local
server. That''s what I am trying to accomplish. No problems when running
locally but OLEDB error when inserting into temporary table output from
linked server. No problems executing SQL without INSERT INTO:
EXEC LAOLAP.master.dbo.sp_helpdb (fine)
INSERT INTO
#tmp_Database(database_name,database_size,owner,dbid,created,status,
compatibility_level)
EXEC LAOLAP.master.dbo.sp_helpdb (error)
Thanks,
Igor
"Steve Kass" <skass@drew.edu> wrote in message
news:eXUX9PNCFHA.3940@TK2MSFTNGP09.phx.gbl...
> Igor,
>
> Does this help?
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;816701
>
> If not, can you provide more details? What versions of SQL Server,
> what operating systems? Anything else mentioned in the article
> that you think applies or doesn't apply to you?
>
> Steve Kass
> Drew University
>
> Igor Marchenko wrote:
>
>>Hello!
>>I am trying to execute following code against linked server LAOLAP:
>>
>>CREATE TABLE #tmp_Database(
>>database_name sysname,
>>database_size nvarchar(13) null,
>>owner sysname,
>>dbid smallint,
>>created nvarchar(11),
>>status nvarchar(600),
>>compatibility_level tinyint
>>)
>>INSERT INTO
>>#tmp_Database(database_name,database_size,owner,dbid,created,status,
>> compatibility_level)
>>EXEC LAOLAP.master.dbo.sp_helpdb
>>
>>I am getting follwoinf error:
>>'The operation could not be performed because the OLE DB provider
>>'SQLOLEDB' was unable to begin a distributed transaction.'
>>
>>DTC is running on both source and target servers. I need to grab output of
>>sp_helpdb from linked server. Is there a work around to make this work? I
>>simply need to determine RECOVERY model in all databases on linked server.
>>
>>Any help would be greately appreciated.
>>
>>Igor
>>
>>
- Next message: John Kane: "Re: SQL2000 5 times slower than SQL7 queries using LIKE '%SearchVa"
- Previous message: Steve Kass: "Re: Executing INSERT INTO EXEC against linled server"
- In reply to: Steve Kass: "Re: Executing INSERT INTO EXEC against linled server"
- Next in thread: oj: "Re: Executing INSERT INTO EXEC against linled server"
- Reply: oj: "Re: Executing INSERT INTO EXEC against linled server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
