Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
syswizard
Starting Member
2 Posts |
 Posted - 2009-06-19 : 09:57:03
|
| Via SSMS I can export stored procedures to any drive on the network.However, when I attempt to do a DIR via XP_CmdShell, I can't "see" anything except the drive of the server in which my instance of SQL Server resides.What needs to be done to that server to provide cross-domain visibility ? Just add shares to my required network drives ? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-19 : 10:15:16
|
exec master..xp_cmdshell "dir \\servername\foldername"works for me.GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
syswizard
Starting Member
2 Posts |
Posted - 2009-06-19 : 11:08:51
|
| I get:"The system cannot find the path specified"It appears the server is somehow locked out of the network as far as SPROCS are concerned.Wierd - I can see the network from SSMS however.Could this be a permissions issue ?Sorry - I posted this to the 2000 forum when in fact this is SSMS 2005. |
|
|
|
|
|
|
Network "visibility" problem