That might help. I remember turning on auto commit once helped me with some DTS package that was failing with a remote SQL server.. Together with this I also remembering having to turn ANSI on..
Joe From: LJ LongWing Sent: Monday, October 03, 2011 10:51 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: SQL Link Server Issue ** Rafael, Have you checked out the last post in this thread? http://www.sqlservercentral.com/Forums/Topic290774-146-1.aspx#bm290825 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rodriguez, Rafael J x23718 Sent: Monday, October 03, 2011 8:14 AM To: [email protected] Subject: Re: SQL Link Server Issue ** I have done this and the query runs fine on Query Analyzer. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Monday, October 03, 2011 10:10 AM To: [email protected] Subject: Re: SQL Link Server Issue ** Ok…I would then turn on SQL logging and capture the exact SQL Remedy is generating, and see if you can execute that via Query Analyzer without error….ideally query analyzer running on your remedy server J From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rodriguez, Rafael J x23718 Sent: Saturday, October 01, 2011 6:44 PM To: [email protected] Subject: Re: SQL Link Server Issue ** Yes, I’m able to do an insert from SQL client with no problems using the same account. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Friday, September 30, 2011 3:32 PM To: [email protected] Subject: Re: SQL Link Server Issue ** Rafael, Are you able to do an insert directly from a db client into that table?...it may be related to the permissions between the two db’s for the user in question. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rodriguez, Rafael J x23718 Sent: Friday, September 30, 2011 12:55 PM To: [email protected] Subject: SQL Link Server Issue ** Hello list, we are facing the following issue. We have 2 databases on the same SQL server. For this example ARS1 and ARS2. We have created a linked server so we can create a view form from ARS1 to ARS2. When we try to push data from a table on ARS1 to table on ARS2 using the view form created we get the following error: Transaction context in use by another session. (SQL Server 3910) I’ve looked up this error on Microsoft siete and it states that there was a hotfix for this on SQL7/SQL2000. We are currently using SQL2008 SP2. Has anyone seen this issue and has been able to resolve? Thanks in advance. Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<image001.gif>>
