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

  • June 4, 2007 at 9:06 am

    #710621

    Do you want to try this one:

    CREATE TABLE #tmp (strData VARCHAR(1000))

    INSERT INTO #tmp EXEC xp_cmdshell 'dir c:\myFile'

    SELECT * FROM #tmp WHERE strData LIKE '%/%/%'

    DROP TABLE #tmp