To determine whether a compiled object has been upgraded,
do one of the following:
Look
at the sysprocedures.version column. If the
object was upgraded, this column contains the number 12500.
If you are upgrading to a 64-bit pointer
size in the same version, look at the sysprocedures.status column.
It will contain a hexadecimal bit setting of 0x2 to indicate that
the object uses 64-bit pointers. If the bit is not set, the
object is a 32-bit object, which means the object has not
been upgraded.