Retrieving a Stored Procedure from a backup

Is anyone able tell me whether I can retrieve a particular stored procedure
from a backup?
Any help, much appreciated.
Sure. You will first have to restore the database somewhere. Then you can
perform a sp_helptext on the stored procedure.
Keith
"Steven Jones" <Steven Jones@.discussions.microsoft.com> wrote in message
news:68287033-57A5-4035-911B-DEED09D0EA15@.microsoft.com...
> Is anyone able tell me whether I can retrieve a particular stored
procedure
> from a backup?
> Any help, much appreciated.
|||Go for a BMC Product Microsoft SQL BACK TRACK
you can do object level recovery using that .
Thanks
Ajay
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OqRB5199EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Sure. You will first have to restore the database somewhere. Then you
can
> perform a sp_helptext on the stored procedure.
> --
> Keith
>
> "Steven Jones" <Steven Jones@.discussions.microsoft.com> wrote in message
> news:68287033-57A5-4035-911B-DEED09D0EA15@.microsoft.com...
> procedure
>