Deleting files with sql server

• ewalk123

  Grasshopper

  Points: 15

  More actions

  November 26, 2001 at 2:02 pm

  #77628

  I am storing the names of files which have been uploaded to my server in a column called uploaded. All of these files are in the same directory on the server.

  I need to have the actual files deleted when the corresponding record is deleted from the database. Is this possible with a DELETE Trigger? I am very new to T-SQL so any code would be helpful.

  Thanks

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 26, 2001 at 2:26 pm

  #420399

  It is possible. You could use xp_cmdshell to issue a a 'delete filename'.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  November 26, 2001 at 2:40 pm

  #420402

  Be sure to check security. The account under which SQL Server runs needs to have rights to delete these files from the OS.

  Steve Jones

  steve@dkranch.net