accing to shered volumes

Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
> On the same computer i have shered Z: volume which is hard drive on another
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.