help- urgent recover stored procedure

i am using MS-SQL server 2000. i have 2 databases. one is production and the other one is testing. i recently created a testing stored prodcedure in the test database. but forgot that the test database get overwritten everynight because the test database is also treat as the backup database. so how do i restore the store procedure in the test database? help me plz.
Who is Participating?
chapmandewConnect With a Mentor Commented:
It is gone unless you have a backup of the database.
R_JanssenConnect With a Mentor Commented:
It's gone if you are using a real backup and not replication. Always make sure you save your scripts.
StewSupportAuthor Commented:
dang it no other way?
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

BrandonGalderisiConnect With a Mentor Commented:
Or by chance still have it open in Query analyzer somewhere, or saved locally.
StewSupportAuthor Commented:
not the solution i guess there are none so i just give points to you for trying thanks
But it is the solution.  The "solution" is the answer to your question.  And unfortunately, sometimes the answer is there is no way to do it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.