calling exe on a different server

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Anders Pedersen SSChampion Points: 11410 More actions · Answer 1

Which version of windows? Windows 2003 a mapped drive is session specific, so running anything against a mapped drive will not work from within SQL.

pankaj-426531 Ten Centuries Points: 1123 More actions · Answer 2

The OS is windows 2003 NT only. Is there any other way apart from mapping drives.

I have heard linked sever can be used. Do you know anything about it.

Anders Pedersen SSChampion Points: 11410 More actions · Answer 3

UNC names work great.

Permissions need to be set appropriately for that share.

pankaj-426531 Ten Centuries Points: 1123 More actions · Answer 4

Can you please elaborate this method.

What are UNC names.

And how do i use in my stored proc.

Please give the syntax too if possible.

Anders Pedersen SSChampion Points: 11410 More actions · Answer 5

Look up xp_cmdshell in Books Online.

For UNC:

pankaj-426531 Ten Centuries Points: 1123 More actions · Answer 6

I tried to use UNC but its not working. the cmd says it does not support it.

here is the error message:

C:\Documents and Settings\nbkr3bi>cd \\172.17.16.117\apps\Services

'\\172.17.16.117\apps\Services'

CMD does not support UNC paths as current directories.

Is there any other way?