Thanks Chad/Chirag.... I hate to hope that it happens again but if it ever does, i'll try to get the profiler log. cheers!

there was no change in user rights. but if there was any, it shouldn't affect only 1 SP but the whole lot.

cannot be spelling wrong or pointing to wrong DB because it has been running daily. Suddenly couldn't find. furthermore, just re-executed the SP, there was no change to the application....

yes, it was refreshed also. if it wasn't there, i might not be able to script it right? and it only happened to 1 sp... (as far as i know)....

it's all dbo... furthermore, if it's a different owner, the rescripting and execution should remain the same owner, thus seems like it's very unlikely to be this problem.