MSSQL server 2014 express database synchronize to linked server -
i need synchronize linked server primary server in mssql server 2014 express.when modification in primary server should reflect on linked server or secondary server . in express edition mirroring , replication not available. solution this? you try using trigger solve problem. first create trigger actions against local table created test. create on insert, update , delete trigger actions pretty execute same action against test table. once got work, replace test table target linked server table need in sync. let me know if worked you, can talk limitation might face.