Things may be tricky if you don't know where to look below the surface. Turn on your server sql logs and try to load the columns in the admin tool; find the statement in the sql logs that attempts to return the columns, see why it doesn't, then things may not be so tricky. k, tricky maybe?
Axton Grams On Fri, May 23, 2008 at 10:02 AM, tricky maybe <[EMAIL PROTECTED]> wrote: > ** I have a view on SQL that I want to load on Remedy so I open the admin > tool and click on new object then I select view form and type in my database > table ARSystem.dbo.MyViewForm and when I click on load I don't get an error > but there's no available columns showing up. MyViewForm is a view I created > from a linked server using SQL. I can query that view on SQL using > management studio with no problem. Do you know why I can't load it on > Remedy or can someone show me how how to do this? Thanks > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
