Post reply

Stored Procedure Recovery

  • October 3, 2006 at 12:34 pm

    #153215

    Hi

    I created a new SP with the same name of another one, does anybody know how I can recover the old one?

    Regards

  • October 3, 2006 at 12:55 pm

    #663936

    Do you have a database backup?  I take it there is no version control on your SP's, hence no old version saved? 

    I wasn't born stupid - I had to study.

  • October 3, 2006 at 3:13 pm

    #663964

    No I haven't a DB backup, no old version saved, there is some version control in VSS but it doesn't have the latest version upgraded.

    Regards

  • October 4, 2006 at 7:34 am

    #664085

    If you don't have a backup, you can not recover the original procedure. It was overwritten with the new one.

    I suppose you used ALTER PROCEDURE, because if you use CREATE and the procedure already exists, you receive an error and the original version would still be there.

  • October 4, 2006 at 10:25 am

    #664131

    Ok

    So, let's do it again.

    Thank you so much.

    Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply