All,
ARS 7.1 p4 WINXP SQL2000 We are migrating all of our databases except ARSYSTEM to SQL2008. There are external processes which we have view forms to other database table. I then use these view forms to update and delete records. That table will be moving to SQL2008 In order to keep this functionality we created a linked sever between the Arsystem 2000 db server and the 2008 db server. We then created views on the 2000 server that looks at tables on the 2008 server. I then created view forms to these views. I am trying to update data in these views which will then be pushed to the actual tables in the 2008 database. The problem we are running in to is this: /UPDATE T533 SET C720001106='XXXCKelley3' WHERE C1 = '8928' <SQL > <TID: 0000001968> <RPC ID: 0000084036> <Queue: Fast > <Client-RPC: 390620 > <USER: rnall > /* Mon Mar 02 2009 13:58:16.9760 */* WARNING * Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. (SQL Server 7395)OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction retur <SQL > <TID: 0000001968> <RPC ID: 0000084036> <Queue: Fast > <Client-RPC: 390620 > <USER: rnall > /* Mon Mar 02 2009 13:58:16.9760 */ROLLBACK TRANSACTION <SQL > <TID: 0000001968> <RPC ID: 0000084036> <Queue: Fast > <Client-RPC: 390620 > <USER: rnall > /* Mon Mar 02 2009 13:58:17.0540 */*** ERROR *** The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) <SQL > <TID: 0000001968> <RPC ID: 0000084036> <Queue: Fast > <Client-RPC: 390620 > <USER: rnall > /* Mon Mar 02 2009 13:58:17.0540 */OK We are trying figure out how to turn the XACT_ABORT option to ON as Remedy is trying to make its update/delete. I am wondering if anyone can give us some suggestions on how to accomplish this. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
