1. Luis Martin Moderator

   One of clients "lost" xp_cmdshell store procedure. (2000 SP4).
   Any way to install this xp without installing all 2000 again?
   

   Luis Martin, Jul 14, 2008

   #2
2. moh_hassan20 New Member

   you can restore the extended procedure :
   use master
   declare @dll_file varchar(100)
   -- path of dll , you can modify it based on the installation drive of sql
   set @dll_file = 'Crogram FilesMicrosoft SQL ServerMSSQLBinnxplog70.dll'
   exec sp_addextendedproc 'xp_cmdshell', @dll_file
   

   moh_hassan20, Jul 14, 2008

   #3
3. Luis Martin Moderator

   Thank you, it works.
   

   Luis Martin, Jul 14, 2008

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in