xp_cmdshell

• parasu

  Default port

  Points: 1400

  More actions

  September 10, 2001 at 10:23 pm

  #101023

  Hello all,

  I dropped my xp_cmdshell from the master database sometime back due to the security issues.

  Now I think I should need it. How do I re-create the xp_cmdshell.

  And also, I want to disable it kindof. So that noone uses it. How do I do this.

  Thanx

  Parasu Raman

  
  Regards
  Parasu Raman

• K. Brian Kelley

  SSC Guru

  Points: 114562

  More actions

  September 11, 2001 at 7:57 am

  #418164

  To add it back, it depends on your version.

  SQL Server 7:

  EXEC sp_addextendedproc 'xp_cmdshell', 'xpsql70.dll'

  SQL Server 2000:

  EXEC sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'

  K. Brian Kelley

  bk@warpdrivedesign.org

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley