Root Directory....

How to read the root directory programatically.
SQL2K.
Thank you,
SmithAs far as I remember there is only
exec xp_subdirs 'c:'
for directories but you can also try
exec xp_cmdshell 'dir c:'
Ben Nevarez, MCDBA, OCP
Database Administrator
"Lowry Smith" wrote:

> How to read the root directory programatically.
> SQL2K.
> Thank you,
> Smith
>
>

Root Directory....

How to read the root directory programatically.
SQL2K.
Thank you,
SmithAs far as I remember there is only
exec xp_subdirs 'c:\'
for directories but you can also try
exec xp_cmdshell 'dir c:\'
Ben Nevarez, MCDBA, OCP
Database Administrator
"Lowry Smith" wrote:
> How to read the root directory programatically.
> SQL2K.
> Thank you,
> Smith
>
>