How to get file date using xp_cmdshell?

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  July 6, 2015 at 2:21 pm

  #1810574

  SQL-DBA-01 (6/5/2015)

  ---

  HI Jeff,

  Is this possible to club the details of all the folders/files if one mentions any location/path???

  This one is only working against files and a v nice one as it says what kind of filetype they are. But kind of consolidation would be great.

  Sorry for the late reply.

  Yes. You should be able to modify the code to do so.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)