Per recommendation above, I'll post my tip/solution to get the ball rolling.
Stack has a nice example of the xp_cmdshell at:
[
^]
Using the example you'll first need to configure the xp_cmdshell using sp_configure as shown below (if you don't have permissions, you'll need a System Admin or DBA to run it for you):
Use Master
GO
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE WITH OVERRIDE
GO
Now you can run xp_cmdshell.
EXECUTE master.dbo.xp_cmdshell 'DIR "C:\YourDirectory" /A-D /B'
It works nice. It shows up in the results window in the familiar tabular format.