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 8:23 am

    #911121

    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.

    -Roy