Deleteing a disk file

• ouertani neked

  SSC-Addicted

  Points: 406

  More actions

  June 8, 2004 at 10:03 am

  #152177

  Hi every body,

  Question: How can  I delete a file on the disk from my T-SQL SP

  Thanks

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  June 8, 2004 at 10:16 am

  #509521

  exec master..xp_cmdshell 'del c:\whateverthefilenameis'

   

  xp_cmdshell is locked down by default (for good reason), be extremely wary doing this, all kinds of bad things can happen

  ---

  
  Shamless self promotion - read my blog http://sirsql.net