• I think there is a miscommunication..... with the message I have posted.

    As Gail Shaw mentioned if you have backup of the database where you have the previous version of the procedure you can restore using the backup.

    I mean to say if we have backup ... where we have older version of the procedure.... we can restore to the previous version.. by restoring the database backup... and taking old sp from that backup.

    I think it was a misunderstanding. I've never heard of a mechanism for doing this either.

    Yes there is not mechanism for restoring to the previous version with any other method.