im using the xp_cmdshell command in a query to try to access a mapped drive that i have on a server. example:
Exec master.dbo.xp_cmdshell 'dir Z:\'
i found that in another forum online and it does not seem to work, i looked in another sql 2008 book, and there was nothing on this as far as synatax.
with no luck.
does this proc work for anyone.
Note: i did enable SQL Server Surface Area Configuration prior.
any help is appreciated.