SQL Server Performance


Discussion in 'General DBA Questions' started by Luis Martin, Jul 14, 2008.

  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?
  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 = 'C:program FilesMicrosoft SQL ServerMSSQLBinnxplog70.dll'
    exec sp_addextendedproc 'xp_cmdshell', @dll_file
  3. Luis Martin Moderator

    Thank you, it works.

Share This Page