通过MSSQL查询当前硬盘数天内发生修改过的文件

DECLARE 
	@disk varchar(3),
	@date datetime

--EXEC sp_configure 'show advanced options', 1;
--RECONFIGURE;
--EXEC sp_configure 'xp_cmdshell', 1
--RECONFIGURE;
--EXEC sp_configure 'show advanced options', 0;
--RECONFIGURE;
SELECT
	@disk = 'D',
	@disk = @disk + ':\',
	@date = DATEADD(day,-8,getdate())

IF OBJECT_ID(N'tempdb.dbo.#moron', N'U') IS NOT NULL 
	DROP TABLE #moron

IF OBJECT_ID(N'tempdb.dbo.#t', N'U') IS NOT NULL 
	DROP TABLE #t

CREATE TABLE #t (
	info varchar(max))

INSERT #t
EXEC('xp_cmdshell ''dir ' + @disk + ' /s /o:-d''')

DELETE FROM #t
WHERE info LIKE '%Volume in%'
	OR info LIKE '%Volume Serial%'
	OR info LIKE '%Directory of%'
	OR info LIKE '%File(s)%'
	OR info IS NULL
	OR info LIKE '%<DIR>%'
	OR info LIKE '%Dir(s)%'
	OR info LIKE