reza141414

1- using trigger to sync 2 tbl in 2 database==> it's not good becuse data in Emp tbl are too many and storing these data in 2 place is not googd suggestion.is't it?

If employee tables contain too many than you can use linked server to access it or create one webservice to fetch data from this database.