Home Forums SQL Server 2005 SQL Server 2005 General Discussion retrieve the previous version of a stored procedure RE: retrieve the previous version of a stored procedure

  • December 11, 2008 at 9:17 am

    #911181

    Roy Ernest (12/11/2008)

    Kishore.P (12/10/2008)

    Gauthama Kolivad (12/10/2008)

    Using the same DB... I mean without using backup ... we cant restore a stored procedure to the previous version.

    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.

    you can generate the script the sp for previous ver. if it is not encrypted.

    I would really like to know how this can be done.... Never heard of any method to do this.

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

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning