Recently, on a Friday evening, we released an update to one of our core applications. As expected, it went smoothly and no issues were noted. On the following Monday morning, however, the story took a different turn when end users started reporting issues. One of the issues encountered was related to a new stored procedure.
In looking at the procedure, we found there were references to a database that existed within the QA environment but did not in Production. It was assumed that when the procedure was created, it would throw an error because the database referenced didn’t exist.