September 22, 2010 at 4:24 am
@r.dragoi-1095738, @learningforearning - thanks for your help so far
@r.dragoi-1095738 - i ran the statement you gave ...
i'm not sure if it was doing this before but when I removed the
INSERT #Drive
statement on my script it gives me results already
if I include the INSERT statement it gives me the error
OLE DB provider "SQLNCLI10" for linked server "DEV\SERVER1" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "DEV\SERVER1" was unable to begin a distributed transaction.
What I want is to insert the data pulled from a linked server to a table on my local instance
September 22, 2010 at 4:26 am
have you tried the one which i mentioned?
remove the extra exec here
so your @command_01 will be '['+@ServerName+'].master.dbo.xp_fixeddrives'
----------
Ashish
September 22, 2010 at 5:52 am
@learningforearning
yes I tried what you suggested and it works, problem right now is if I insert the result to my local instance I still get the same error .. so it might be the INSERT statement all the while that was causing the error instead of the sp_executesql
September 22, 2010 at 6:31 am
This was removed by the editor as SPAM
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply