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. If the object has been upgraded, and is using 64-bit pointers, this column contains a hexadecimal bit setting of 0x2 to indicate that the object uses 64-bit pointers. If this bit is not set, it indicates the object is still a 32-bit object, and has not been upgraded.