Subject Stored Procedure BORKED
Author Jason Dodson
Hey all,

I came in this morning to a list of complaints that data was missing. Upon investigation, it ended up being a stored
procedure was returning nothing. This procedure hasn't changed in two years, so as to what the cause could be was
puzzling. I started a lengthy process of debugging this procedure only to find that there was no logic error. This
should be returning data. After some playing around, I ended up using the metadata of this procedure and made an
identical one, appending "test" to the end of the procedure name. Weirdly enough, this new procedure works as the old
one was expected to. I was able to then drop the procedure and recreate it with exactally its own metadata definition...
not changes at all... and now it works.

Should I be concerned?

Jason

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.