Hi,
No, you must recreate/delete the correct indexes manually if you have
started along that path... You must make sure they have the correct
permissions to allow the AR System to delete them.
You can turn on SQL-logging to see exactly what AR Admin tries to do when
it fails. This will guide you in the fixup of the corrupted database.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
