Re: OT: SQL2008

2009-03-02 Thread Nall, Roger
discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of James Lauber Sent: Monday, March 02, 2009 4:47 PM To: arslist@ARSLIST.ORG Subject: Re: OT: SQL2008 We had a similar, but not identical, issue with inserting to tables via a linked server. We added this to the ardb.cfg file

Re: OT: SQL2008

2009-03-02 Thread James Lauber
We had a similar, but not identical, issue with inserting to tables via a linked server. We added this to the ardb.cfg file, restarted the service and it resolved the issue. Don't know if it will help for your problem but it's worth a shot. DB-Options:SQL Server { name:XACT_ABORT value:ON } Andy

OT: SQL2008

2009-03-02 Thread Nall, Roger
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 kee