If you put Sacred Stone to weapon, that already has special effect (for example bow has Purge), the effect of Sacred Stone will override the Purge. The only exceptions are GoF and Sacrifical Strike, where you can put one Sacred Stone, and both effects will work.