im using the xp_cmdshell command in a query to try to access a mapped drive that i have on a server. example:
Code:
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.
i tried
Code:
'z:\'
'z:\ \\dcserver\beast'
'\\dcserver\beast'
with no luck.
does this proc work for anyone.
Note: i did enable SQL Server Surface Area Configuration prior.
any help is appreciated.
thx
Mapping drive for sql backup
