September 15, 2009 at 1:23 am
Hi, is there any code in command prompt (which i can execute using xp_cmdshell ) to open a directory?
September 15, 2009 at 8:37 am
explorer.exe is the executable that you can run...
eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.. 🙁
September 15, 2009 at 8:52 am
What are you trying to accomplish? When you shell out, you aren't using your login, you're using a service account (or proxy) login. running explorer.exe won't get you anything.
September 15, 2009 at 6:53 pm
ps (9/15/2009)
explorer.exe is the executable that you can run...eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.. 🙁
PS, i've tried using explorer c:\, and it worked in command prompt... but it made me sad that it doesn't work in xp_cmdshell...
I want to open a folder using xp_cmdshell because when i execute xcopy using xp_cmdshell to auto copy my backup file to another destination, xcopy only copies my backup file when the destination folder is open. when it's not open, my job for xcopy returns "succeeded" but it didn't really copied my backup file to the destination... is there anything you can suggest for my problem?
September 15, 2009 at 6:55 pm
ps (9/15/2009)
explorer.exe is the executable that you can run...eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.. 🙁
PS, i've tried using explorer c:\, and it worked in command prompt... but it made me sad that it doesn't work in xp_cmdshell...
I want to open a folder using xp_cmdshell because when i execute xcopy using xp_cmdshell to auto copy my backup file to another destination, xcopy only copies my backup file when the destination folder is open. when it's not open, my job for xcopy returns "succeeded" but it didn't really copied my backup file to the destination... is there anything you can suggest for my problem?
September 15, 2009 at 6:57 pm
ps (9/15/2009)
explorer.exe is the executable that you can run...eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.. 🙁
PS, i've tried using explorer c:\, and it worked in command prompt... but it made me sad that it doesn't work in xp_cmdshell...
I want to open a folder using xp_cmdshell because when i execute xcopy using xp_cmdshell to auto copy my backup file to another destination, xcopy only copies my backup file when the destination folder is open. when it's not open, my job for xcopy returns "succeeded" but it didn't really copied my backup file to the destination... is there anything you can suggest for my problem?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply