Overriten script in SQL Server

Question

I overwrote my Stored Procedure with a old script by mistake. I dont want to re code everything again.

Is there any way I can get the old Stored Procedure script?

Answer 1

If you have a backup of the database, it will contain the stored procedures that were in the DB at the time of the backup. You can restore it to another DB or server and get the code from there.

Answer 2

Extract it from a backup of your database. That's about it, i'm afraid.

Answer 3

You'll have to restore it from a backup.