file attributes

• srirammanoj

  Valued Member

  Points: 55

  More actions

  July 8, 2008 at 12:31 pm

  #194836

  I am trying to retrieve the files attributes like CREATED DATE and wanted to delete files which has datediff as 10 days.

  and I got to add this as ManagementJob in SQL 2005.

  I activated xp_cmdshell to run the commands.

  1. How can i get the file attributes in T-SQL

  2. I got to delete the files who have datediff > 10

  Please post if anyone knows...

  Thanks and Regards,

  Manoj.