setting on/off

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  January 19, 2011 at 8:31 am

  #243830

  Hi Friends,

  We have set up linked server to access Oracle database. We get this error 'A nested transaction was required because the XACT_ABORT option was set to OFF. (7395)' when there is data modification(insert,update,delete to Oracle tables) done from the application. Is there a way to make this setting ON at the database level or through linked server, so we don't have to set this parameter ON for every insert,delete,update operation?

  Thank you

• Abhilash Melethil

  Old Hand

  Points: 303

  More actions

  January 19, 2011 at 8:46 am

  #1275360

  http://www.sqlservercentral.com/Forums/Topic733163-149-1.aspx - this is the answer you are looking for