xp_cmdshell problem

[spykhov]

Hallo to everybody.
I have a problem in SQL Server 2005 / Windows 2000
SQL Server is installed in local drive.

Trying to run the simple sql procedure

exec master.dbo.xp_c mdshell 'dir P:'

I have the response (P: is network drive).
"The network name cannot be found."

For local drives it's O.K., no problems.
What should be done the xp_cmdshell will see network drives?

Someone can help me?

[ramasp]

Hi,

if you want to see the directories in a server then the folllowing is the command
exec master.dbo.xp_c mdshell 'dir'

you can use all dos commands here. if you are connected to a server, then u will get the details of server, otherwise u will get the details of local machine.

[spykhov]

Thanks!
I've found out the solution of my problem.
The Server Service should be changed from Local to my user ID account.