I try to enable the transactional replication with updatable subscriptions and it throws me an error, but I looked for information and it tells me to run the following procedure, but it does not work for me:
exec sp_link_publication @publisher = 'GEA-SRVDATA\SQLSERVER2008'
, @publisher_db = 'PalmComSync'
, @publication = 'Palm83'
, @security_mode = '1'
, @login = 'sa'
, @password = 'taramaca01$'
, @distributor = 'GEA-PALM\GEAPALMSERVER'
When I try to run this procedure it throws me the following error, O
LE DB provider "SQLNCLI10" for linked server "REPLLINK_GEA-SRVDAT838186658_PALMCOMSYN596908474_PALM831306616318_ALASKA_PCO691301400" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "REPLLINK_GEA-SRVDAT838186658_PALMCOMSYN596908474_PALM831306616318_ALASKA_PCO691301400" was unable to begin a distributed transaction.
help,