Linked Server ... solo in lettura?

 sp_addlinkedserver 
@server = 'link_vSync' , 
@srvproduct = ' ', 
@provider   =  'SQLOLEDB', 
@datasrc = " + RemoteSQLServerName + ", 
@location =  RemoteNameComputer , 
@provstr  =  NULL, 
@catalog = N"RemoteSQLDBName" 

SELECT   *
INTO  <nomelinkedserver>.<nomedb>.dbo.<nuovatabella>
FROM   <tabellalocaledacopiare>

The object name <linkedserver>.<nomedb>.dbo. contains 
more than the maximum number of prefixes. 
The maximum is 2.

SELECT col1,..., coln INTO dbo.TabellaDiDestinazione
FROM linkedserver.database.dbo.TabellaDiOrigine;

INSERT linkedserver.database.dbo.TabellaDiDestinazione
SELECT col1,..., coln
FROM dbo.TabellaDiOrigine;

exec <linkedserver>.<database>.dbo.sp_executesql 
N'create table dbo.testtable (  col1 char(10) )'

use master
exec sp_serveroption 'linkedserver' , 'rpc' , 'on' 
exec sp_serveroption 'linkedserver' , 'rpc out' , 'on' 

BEGIN TRAN
ROLLBACK TRAN
COMMIT TRAN

The operation could not be performed because the
 OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
 ITransactionJoin::JoinTransaction returned 0x8004d01c].