Link to home
Start Free TrialLog in
Avatar of StewSupport
StewSupport

asked on

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.
SOLUTION
Avatar of R_Janssen
R_Janssen
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of StewSupport
StewSupport

ASKER

dang it no other way?
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.