I have done this and the query runs fine on Query Analyzer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, October 03, 2011 10:10 AM To: arslist@ARSLIST.ORG 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 :) From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rodriguez, Rafael J x23718 Sent: Saturday, October 01, 2011 6:44 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, September 30, 2011 3:32 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Rodriguez, Rafael J x23718 Sent: Friday, September 30, 2011 12:55 PM To: arslist@ARSLIST.ORG 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 [cid:image001.gif@01CC81B5.3366F1B0] This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<inline: image001.gif>>