I have a problem creating a view form- thanks to Joe's advice I am now able to see all the columns. My problem now is designating a key field. The only column which is guaranteed to be unique is a GUID passed from the external data source, but it's too long- 25 characters.
Has anyone else run into this problem, and how did you get around it? I can't use ROW_ID because this table will be overwritten monthly. I know just enough SQL to be dangerous...is there some sort of way to add a column and ensure it's unique via SQL? ITSM 7.0.1 p6 SQL 2005 SP2 Win 2003 svr I appreciate any advice! Chris _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
