InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 15:16:00 GMT20http://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxPlease note: 4 year old threadWed, 27 Mar 2013 08:43:33 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxYou can restore it from a database backup even without restoring the backup. You need a tool for comparing and synchronizing object schemas (such as SQL Diff). Set the database backup as a source, the live database as a destination, filter only the stored procedure you want to restoreWed, 27 Mar 2013 08:26:17 GMTjanet.marplehttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxI think there is a miscommunication..... with the message I have posted.[quote]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.[/quote]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.[quote]I think it was a misunderstanding. I've never heard of a mechanism for doing this either.[/quote]Yes there is no mechanism for restoring to the previous version with any other method.Thu, 11 Dec 2008 23:05:49 GMTbrainyhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxI think there is a miscommunication..... with the message I have posted.[quote]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.[/quote]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.[quote]I think it was a misunderstanding. I've never heard of a mechanism for doing this either.[/quote]Yes there is not mechanism for restoring to the previous version with any other method.Thu, 11 Dec 2008 23:05:09 GMTbrainyhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspx[quote][b]Roy Ernest (12/11/2008)[/b][hr][quote][b]Kishore.P (12/10/2008)[/b][hr][quote][b]Gauthama Kolivad (12/10/2008)[/b][hr]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.[/quote]you can generate the script the sp for previous ver. if it is not encrypted.[/quote]I would really like to know how this can be done.... Never heard of any method to do this.[/quote]I think it was a misunderstanding. I've never heard of a mechanism for doing this either.Thu, 11 Dec 2008 09:17:44 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspx[quote][b]Kishore.P (12/10/2008)[/b][hr][quote][b]Gauthama Kolivad (12/10/2008)[/b][hr]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.[/quote]you can generate the script the sp for previous ver. if it is not encrypted.[/quote]I would really like to know how this can be done.... Never heard of any method to do this.Thu, 11 Dec 2008 08:23:34 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspx[quote][b]Grant Fritchey (12/10/2008)[/b][hr]Pull a previous copy out of source control...If you don't have your code under source control, here's the wake-up call to get it there.You can't retrieve a previous copy from the current database. It's gone.[/quote]I second that!Thu, 11 Dec 2008 07:33:10 GMTMauvehttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxPull a previous copy out of source control...If you don't have your code under source control, here's the wake-up call to get it there.You can't retrieve a previous copy from the current database. It's gone.Wed, 10 Dec 2008 07:42:38 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspx[quote][b]Kishore.P (12/10/2008)[/b][hr][quote]you can generate the script the sp for previous ver. if it is not encrypted.[/quote]How, if the proc has been written over?Wed, 10 Dec 2008 01:59:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspx[quote][b]Gauthama Kolivad (12/10/2008)[/b][hr]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.[/quote]you can generate the script the sp for previous ver. if it is not encrypted.Wed, 10 Dec 2008 01:46:16 GMTKishore.Phttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxUsing 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.Wed, 10 Dec 2008 01:04:08 GMTbrainyhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxFind a backup of the DB that has the version of the proc that you want. Restore that alongside the existing DB and then script out the procedureWed, 10 Dec 2008 00:22:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic616678-149-1.aspxHi Is there any way to retrieve the previous version of a stored procedure after compilation and closing the window?please please helpregardspoojaTue, 09 Dec 2008 22:47:43 GMTPooja_prasad