Search

Wednesday, July 27, 2011

Undocumented sp for listing files

Often we need to know what sorts of files we have on an disk or in an folder. One fast way to find out is to use this xp:

master.dbo.xp_dirtree 'd:\' ,1 ,1

This will list all files in the root or the sub directory we point out.
Se this link: http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1270919,00.html for a list of undocumented sp, on which version they can be run and how to use them. Recmomended!

No comments:

Post a Comment