February 16, 2006 at 9:20 am
Hi
I am trying to retreive information from all the SQL server database and put it into a local table to process.
use RIZVIS
create table sajCPUUser
(index_c varchar(20), [name] varchar(20), internal_value varchar(50), character_val varchar (1000))
Im then running the insert statement
insert rizvis.admin.dbo.sajcpuUser (index_c, [name], internal_value, character_val)
exec myServer.master.dbo.xp_msver
/*select * from sajcpuUser
drop table sajcpuUser */
and I get:
Server: Msg 7391, Level 16, State 1, 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].
However wen I run
exec myServer.master.dbo.xp_msver on its own, I get the correct full results.
What am I doing wrong ?
Regards
February 16, 2006 at 11:17 pm
Hi,
Create the linked server then execute the query like this
exec [192.234.5.3].[master].[dbo].[sp_who]
from
Killer
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply