I'm running SharePoint 2010 and SQL Server 2008 R2.
It's hugely important that I create a list of every file within a given content database that has been modified today, 10/31. Will this query do it or will it leave anything -anything at all- out?
SELECT [DirName], [LeafeName], [TimeLastModified] FROM [WSS_Content_TARGETDB].[dbo].[AllDocs] WHERE [TimeLastModified] BETWEEN '20121031' AND '20121101';
I'm crossing my fingers that this will list everything without any gaps.