wordtool
asked on
xp_commandshell
Using xp_commandshell how do I just get file/folder names without the attributes and the lines without the Drive volume information into a table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Use Lowfatspread's code and change the dir to use the parameters "/ad /b", so:
exec master.dbo.xp_cmdshell "dir c:\windows /ad /b"