Link to home
Create AccountLog in
Avatar of vijay11
vijay11

asked on

MSSQL Linked Server

Hello,
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"
ASKER CERTIFIED SOLUTION
Avatar of Member_2_4226667
Member_2_4226667

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of vijay11
vijay11

ASKER

Thanks for the reply. Please let me know if is possible to rewrite the query with out enabling this.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of vijay11

ASKER

Thanks