Re: Undelete store procedure

From: Jim Young (thorium48_at_hotmail.com)
Date: 01/15/05 

Date: Sat, 15 Jan 2005 10:53:27 -0800

No. You will need to restore the stored procedure(s) from a backup of the
database or a saved script of the stored procedure. Dropping a stored
procedure is no different than dropping any other database object - once
it's gone it's really gone.

Jim

"Yanto" <yantor@nospam.invalid> wrote in message
news:OR6ptpp%23EHA.608@TK2MSFTNGP15.phx.gbl...
> Hi All,,
> Is it possible to undelete store procedures that accidentally deleted? if
> yes, how to do that?
> TIA
> Yanto
>
>

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)