I sometimes find the Clean Up Database menu option disabled as well, for no apparent reason. It often won't let me open the RI builder in the first place if I don't Clean Up Database first, either from the menu or the command window the way you suggest. After cleaning up and entering the RI builder, I'm pretty sure I still find my problem with loose references to deleted RI procedures. But I admit that it often lets me change relations and rebuild RI without requiring me to Clean Up Database first. It's possible that, all the times I encountered the bug, I failed to Clean Up first, but I doubt it.

>I have SP1&2 installed and find that during developement I very often have to:
>
>SET EXCL ON
>USE XXXX.DBC
>PACK DATABASE
>VALIDATE DATABASE
>
>to get my RI to function properly. Note that both PACK and VALIDATE are done what you select CLEAN UP DATABASE from the (end of the) DATABASE menu. The problem is that I almost always find that that option is greyed out so I have to run the operations manually.
>
>I therefore suggest you try to PACK and VALIDATE (or CLEAN UP) your DB and see if that resolves the prob.
>
>Hope this helps!
>
>
>>Has anybody noticed that if you remove some persistent relations from your database, then regenerate RI, then try to delete stuff, it might tell you it can't find one of the RI programs, and the trigger fails? There appears to be bugs in the RI generator code that don't always clean up references. I usually have to put some relations back in, possible with triggers set to "ignore" in order to make it clear itself and go away.
>>
>>I just felt like grumbling. I haven't installed any service packs or looked for technotes.