December 28, 2009 at 5:06 am
i create a server group and new registration of another sql server
how can i update the table to that new registration from the local server registration
i want to update table thru triggers of another server group
December 28, 2009 at 5:58 am
I guess that is not possible unless you use Linked Server.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 28, 2009 at 4:22 pm
Bru is correct. Each registration is a connection to a separate server. They are not in any way related.
December 28, 2009 at 10:31 pm
linked server ? do you have any sample
thanks
December 29, 2009 at 6:18 am
thermo_ll (12/28/2009)
linked server ? do you have any samplethanks
Have you searched Google for "Linked Server in SQL Server" ? I guess you will get plenty of links to read for the next few days.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 3, 2010 at 4:50 am
i already add linked server in my sql server
now i encounter an error
operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction
when im trying to update the table in the linked server via insert trigger in the local table
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply