How to Retrive Dropped Procedures in SQL Server

Hi,
I had dropped a stored procedure from SQL Server DB.
Please let me know if there is any way retrive the dropped
procedures?
Please help me in finding the solution.
thanks,
athmaram
Well, do you ever take database backups? Do you ever store your procedure
code in source control of any kind? Keep local copies, even? How about the
same procedures from dev/test/staging environments?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Athmaram" <athmaramp@.gmail.com> wrote in message
news:1182814933.762281.75850@.e16g2000pri.googlegro ups.com...
> Hi,
> I had dropped a stored procedure from SQL Server DB.
>
> Please let me know if there is any way retrive the dropped
> procedures?
>
> Please help me in finding the solution.
>
> thanks,
> athmaram
>
|||Hello,
If you have a production staging or QA environment and if the procedure
version is same then pick from there. Or else restore the last days database
backup
with a new name and pick the procedure from there and create it in the
actual database.
Thanks
Hari
"Athmaram" <athmaramp@.gmail.com> wrote in message
news:1182814933.762281.75850@.e16g2000pri.googlegro ups.com...
> Hi,
> I had dropped a stored procedure from SQL Server DB.
>
> Please let me know if there is any way retrive the dropped
> procedures?
>
> Please help me in finding the solution.
>
> thanks,
> athmaram
>