SQL Server to update record in different database alternate solutions

24 views Asked by At

I have DB-A1 which has a table T1 now i need that when ever T1.Status is changed then some columns will be updated on different DB-B1 in table T2.

I know how to achieve this via trigger but the problem is that i don't want to create triggers on DB-A1 due to some restrictions any other alternate way which should not affect the DB-A1 as DB-A1 is not mine.

0

There are 0 answers