Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exec .cmd from xp_cmdshell 1

Status
Not open for further replies.
nice95gle

nice95gle

Programmer
Nov 25, 2003
359
US
Does anyone know how to change the directory using xp_cmdshell and then execute a cmd file from that directory?

I tried the following:
Code: 
xp_cmdshell [COLOR=red]'c:\abcdef\file.cmd'[/color] [COLOR=green]--fails
[/color][COLOR=green]--and 
[/color]xp_cmdshell [COLOR=red]'cd c:\abcdef && file.cmd'[/color] [COLOR=green]--fails
[/color][COLOR=green]--and some other stuff I can't remember right now
[/color]

Well Done is better than well said
- Ben Franklin
 
Sort by date Sort by votes
Sweet...

Well Done is better than well said
- Ben Franklin
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
834
Volvere
V
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
625
bharons
bharons
TheBugSlayer
  • Locked
  • Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's 1
Replies
7
Views
1K
Nick_Evans1
Nick_Evans1
grnzbra
  • Locked
  • Question
GOING FROM DD/MM/YYYY TO MM/DD/YYYY 1
Replies
4
Views
1K
JeffModen
JeffModen
Auguy
  • Locked
  • Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
309
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top