I was trying to track down a bug, and put a couple of Message_box calls in the stored procedure I was looking at. Suddenly, the bug was gone! I swear I made no other changes.
The only theory I could think of was that the existing source code and the deployed compiled code did not match. The guy who worked on this before me must have fixed this problem but somehow managed to deploy the system without compiling the routine (but he must have compiled the routine to test it). Is that possible?
When I did a fuzzy search on this discussion forum for "compile stored procedure", I found a couple of routines that people have written to recompile all the stored procedures. Is it a "best practice" to recompile everything before deploying the system, or am I barking up the wrong tree?
I ALWAYS do this on a fresh load for a new deployment. Otherwise, if it's just patches, etc., I've re-compiled the changes so I don't usually do it then. I also do a SCAN_REP before fresh deployments, too.
Don Miller
C3 Inc.