Listers,
I'm in the process of modifying some indexes and I've run into a
small problem. For some reason, I have some indexes that were created in the
database before they were created in the WAT and some that were deleted from
the database but not the WAT. Consequently, when I try to add or delete them
from the WAT, I get a failure during SQL operation to the database, either
because the index already exists (when I try to add them) or because the index
doesn't exist in the system catalog (when I try to delete them). I've also
tried deleting them from the database first, recreating them with the name that
Remedy believes they should have, and then attempting to delete from the admin
tool, and I still get the error. Is there some easy way to delete or add
indexes if you're in a situation like this?
ARServer and tools are 5.1.2
Database is SQL 2k
OS is Server 2003
Thanks much,
Michael A. McManus, SSgt, USAF
Remedy Developer
HQ 754 ELSG/DOMH
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
