I have two systems A and B which are in the same nerwork.
I have written a stored procedure in data base on System A to execute a batch file on system B using the xp_cmdshell Stored procedure.
The batch file executes the commands but when the command "e:" in batch file executes it goes to the E: command prompt of System A. I need to go to command prompt of System B.
Please let me know how to achieve this.
The code in Stored procedure on System A is:
EXEC master..xp_cmdshell '\\System B\E\Express\Jobs\batchfile.bat'
Batch File Code(on System B):
I am not able to execute batch file 2.bat on E drive of system B from System A.
Batchfile2.bat can execute only under E:\Myfolder as it is dependent on some settings.
Request you to kindly provide some solution.