deleted xp_cmdshell... how do I restore it?

For security reasons I dropped xp_cmdshell from my master database. Now
I find that I need it once again... is there a way to restore it or
somehow copy it from another database server? I've tried to use
enterprise manager to DTS it over but I can't DTS anything from the
master database. Is there any other way?
Thanks in advance.
Rsto create it back use the following and let know if it works:
Use Master
sp_addextendedproc xp_cmdshell, 'xplog70.dll'

delete remnants of log shipping

I deleted all the maintenance plans but somehow the log shipping monitor
showing the log shipping pair still remains. How can i clear all the log
shipping ?
Log shipping can be removed from the Maintenance Wizard. Is that where you
removed log shipping? Run the wizard and when you get to the Log Shipping
tab, click on Remove Log Shipping.
To remove a Log Shipping pair from the monitor, use
sp_delete_log_shipping_monitor_info. This is discussed in detail in BOL so
do a search and you'll find all you need.
joe.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eLoO1N4UFHA.3292@.TK2MSFTNGP14.phx.gbl...
>I deleted all the maintenance plans but somehow the log shipping monitor
> showing the log shipping pair still remains. How can i clear all the log
> shipping ?
>
|||Not that MS supports hacking system tables, but msdb..log_shipping_monitor is
where this info is stored.
If the stored proc doesn't work, I've had to restort to cleaning this out
manually.
DO this at your own risk.
<standard disclaimer inserted here>
Donna Lambert
"Joe Yong" wrote:

> Log shipping can be removed from the Maintenance Wizard. Is that where you
> removed log shipping? Run the wizard and when you get to the Log Shipping
> tab, click on Remove Log Shipping.
> To remove a Log Shipping pair from the monitor, use
> sp_delete_log_shipping_monitor_info. This is discussed in detail in BOL so
> do a search and you'll find all you need.
>
> joe.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:eLoO1N4UFHA.3292@.TK2MSFTNGP14.phx.gbl...
>
>

delete remnants of log shipping

I deleted all the maintenance plans but somehow the log shipping monitor
showing the log shipping pair still remains. How can i clear all the log
shipping ?Log shipping can be removed from the Maintenance Wizard. Is that where you
removed log shipping? Run the wizard and when you get to the Log Shipping
tab, click on Remove Log Shipping.
To remove a Log Shipping pair from the monitor, use
sp_delete_log_shipping_monitor_info. This is discussed in detail in BOL so
do a search and you'll find all you need.
joe.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eLoO1N4UFHA.3292@.TK2MSFTNGP14.phx.gbl...
>I deleted all the maintenance plans but somehow the log shipping monitor
> showing the log shipping pair still remains. How can i clear all the log
> shipping ?
>|||Not that MS supports hacking system tables, but msdb..log_shipping_monitor is
where this info is stored.
If the stored proc doesn't work, I've had to restort to cleaning this out
manually.
DO this at your own risk.
<standard disclaimer inserted here>
Donna Lambert
"Joe Yong" wrote:
> Log shipping can be removed from the Maintenance Wizard. Is that where you
> removed log shipping? Run the wizard and when you get to the Log Shipping
> tab, click on Remove Log Shipping.
> To remove a Log Shipping pair from the monitor, use
> sp_delete_log_shipping_monitor_info. This is discussed in detail in BOL so
> do a search and you'll find all you need.
>
> joe.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:eLoO1N4UFHA.3292@.TK2MSFTNGP14.phx.gbl...
> >I deleted all the maintenance plans but somehow the log shipping monitor
> > showing the log shipping pair still remains. How can i clear all the log
> > shipping ?
> >
> >
>
>

delete remnants of log shipping

I deleted all the maintenance plans but somehow the log shipping monitor
showing the log shipping pair still remains. How can i clear all the log
shipping ?Log shipping can be removed from the Maintenance Wizard. Is that where you
removed log shipping? Run the wizard and when you get to the Log Shipping
tab, click on Remove Log Shipping.
To remove a Log Shipping pair from the monitor, use
sp_delete_log_shipping_monitor_info. This is discussed in detail in BOL so
do a search and you'll find all you need.
joe.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eLoO1N4UFHA.3292@.TK2MSFTNGP14.phx.gbl...
>I deleted all the maintenance plans but somehow the log shipping monitor
> showing the log shipping pair still remains. How can i clear all the log
> shipping ?
>|||Not that MS supports hacking system tables, but msdb..log_shipping_monitor i
s
where this info is stored.
If the stored proc doesn't work, I've had to restort to cleaning this out
manually.
DO this at your own risk.
<standard disclaimer inserted here>
Donna Lambert
"Joe Yong" wrote:

> Log shipping can be removed from the Maintenance Wizard. Is that where you
> removed log shipping? Run the wizard and when you get to the Log Shipping
> tab, click on Remove Log Shipping.
> To remove a Log Shipping pair from the monitor, use
> sp_delete_log_shipping_monitor_info. This is discussed in detail in BOL so
> do a search and you'll find all you need.
>
> joe.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:eLoO1N4UFHA.3292@.TK2MSFTNGP14.phx.gbl...
>
>