Home Forums SQL Server 2005 Administering How to get file date using xp_cmdshell? RE: How to get file date using xp_cmdshell?

  • 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)