> This sounds like what I need but how do I do that?
>
> If I view my stored proc source via IBConsole - this is what I want
> to remove but of course leaving the compiled code intact.
>
> What must I do ?

update rdb$procedures
set rdb$procedure_source = null
where rdb$procedure_name = 'MYPROCEDURE';


Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com