I was able to create a view from the external database but the problem is that
view does not have a field that is required to create a view form on Remedy.
How can I specify the type of field when creating a view using SQL? Thanks
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of Kevin Pulsen
Sent: Friday, May 23, 2008 7:45 AM
To: [email protected]
Subject: Re: No available columns when creating a view form from SQL
**
If you are attempting to create a view form from an external sql
database...
For SQL Server—
TABLENAME or DATABASENAME.OWNER.TABLENAME (Make sure you specify dbo if the
current user is the owner of the table.)
Also make sure ARAdmin has permissions to the sql db you are attempting to
create a view form with.
Syntax -
[INAME\INAME].DBNAME.OWNER.TBNAME
This is the syntax for SQL 2005 with an instance name, the instance name is in
the brackets [INAME\INAME]
You can test it by the following sql query-
select * from [INAME\INAME].DBNAME..OWNER.TBNAME
Is this what you are looking for Tricky?
Kevin P.
__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"
