Is it possibe to set up a trigger in SQL Server 2000 that will update a table on another server that is in a SQL Server 6.5 database? If so, what is the procedure/syntax?
You should add the 6.5 server as a linkled server. Check sp_addlinkedsrv, sp_serveroptions and sp_addlinkedsrvlogin in BOL. And then execute a remote query from the trigger.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply