I need to collaborate with some of you SQL pro's out here to work with me to fetch a list of forms that may have indexes defined in Remedy that may violate a very basic rule in most standard RDBMS's. Indexes in most RDBMS's (Oracle, MS-SQL, Informix etc) that a Remedy server might be using, need to have indexed fields of less than 255 characters in length to the best of my knowledge. First of all I want to CONFIRM that this rule is true for all RDBMS's..
If it is true, then I ran a query to find any fields that may be indexed and violating this basic rule.. I can share this query with you if you want to join me on a collaborated effort to list all schemas that have fields that are indexed that may indeed be greater than 254 characters. Any volunteers? I have a ready query I can share with you.. Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

