Unanswered: How to create triggers in different database servers
I am trying to create a trigger on table A existing in Database A on Server A which on insert,update,delete would reflect these changes on table B in DatabaseB on Server B. I wrote the following syntax but it doesnt work
CREATE trigger trg_upd_tableA
--update the fields
declare @cust_no varchar
SELECT @cust_no = cust_no FROM inserted
entity_type_cd = 'MFG',
cust_no = 6699,
name_en = 'NOVARTIS',
where cust_no= @cust_no
I get the error below
Another user has modified the contents of this table or view ; the database row you are modifying no longer exists in the database
Database Error: '[Microsoft][ODBC SQL Server Driver][SQL Server] MSDTC on server 'DatabaseB' is unavailable'
I would like anyone to reply to me as soon as possible please because i need the solution urgently
It would appear from the error message that the MSDTC service is either not installed or not running on ServerB. Can you check and verify that it is up and running? Make sure that the DTC service is set to Auto Start.