Has anyone come accross this problem.
I use either SQLyog or MySql Query Browser to connect to the remote sql server, create a new stored procedure function. Run execute to store it then all is ok.
The sever seems to "lose" the stored procedure after a day or so for no apparent reason.
If I go in to edit it - the "bare bones" of the stored procedure is there but the content is not anymore.
So I have to delete the stored proc and then create it again.
If I do the same on my dev server at home, no problems.
Any ideas please, its driving me up the wall !!!!