MSSQL Linked Server
Posted on 2016-08-04
we had 2 databases 'abc' and 'xyz' on server 'A'. we used to execute trigger on 'xyz' server(if insert data to a table) and inside trigger we used to execute proc 'proc1' on 'abc' server . 'proc1' used to call another proc in 'abc' database which inserts some data on 'abc' database
Now 'abc' and 'xyz' are moved to 2 different servers . Inside trigger on 'xyz' server I am executing proc with linked server . But now I am receiving "linked server unable to begin distributed transactions. Oledb provider for linked server returned message the transaction manager has disabled its support for remote\network transactions"