Re: SQL Link Server Issue

2011-10-04 Thread Rodriguez, Rafael J x23718
To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Rodriguez

Re: SQL Link Server Issue

2011-10-03 Thread LJ LongWing
] 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

Re: SQL Link Server Issue

2011-10-03 Thread Rodriguez, Rafael J x23718
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

Re: SQL Link Server Issue

2011-10-03 Thread LJ LongWing
AM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, October 03, 2011 10:10 AM To: arslist

Re: SQL Link Server Issue

2011-10-03 Thread Joe Martin D'Souza
: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG

Re: SQL Link Server Issue

2011-10-01 Thread Rodriguez, Rafael J x23718
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

Re: SQL Link Server Issue

2011-10-01 Thread Rodriguez, Rafael J x23718
Subject: Re: SQL Link Server Issue ** What compatibility mode are you running your SQL database in? The Server could be 2008 but it is possible to run the database in a lower compatibility mode. Are you running these the AR System databases in a lower compatibility mode? If so that could

SQL Link Server Issue

2011-09-30 Thread Rodriguez, Rafael J x23718
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

Re: SQL Link Server Issue

2011-09-30 Thread LJ LongWing
: 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

Re: SQL Link Server Issue

2011-09-30 Thread Joe Martin D'Souza
: public.remedy.arsystem.general 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