SELECT entry from creature_template WHERE ScriptName='npc_valiant';
UPDATE creature_template SET ScriptName='' WHERE ScriptName='npc_valiant';