Overriten script in SQL Server

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 开发者_JAVA技巧Stored Procedure script?

---

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.

---

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

---

You'll have to restore it from a backup.