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