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 |
|
dodi
Starting Member
9 Posts |
 Posted - 2003-11-06 : 10:53:06
|
| hi allI need a store proc that can "Shell or run" or wht ever an exe |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-11-06 : 12:01:35
|
| xp_cmdshell ... look it up in Books OnlineJay White{0} |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-06 : 13:14:31
|
| Make sure you do NOT use xp_cmdshell to run things like Word, Outlook, or Internet Explorer. Do not run any program that doesn't automatically close itself. A program that has a user interface or requires user input to terminate will hang and potentially crash SQL Server. |
|
|
|
dodi
Starting Member
9 Posts |
Posted - 2003-11-09 : 03:15:33
|
| Thank's for the the help my mistake was i tried running the calcon with the xp_cmdshell |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-09 : 04:02:00
|
| Oh my god.Why would you want to do that ?Damian |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-11-09 : 04:07:39
|
| Oho!! calc.exe... I think it was miner.exe :) |
|
|
|
dodi
Starting Member
9 Posts |
Posted - 2003-11-09 : 07:52:15
|
What i am tring to do is I have a station DB that needs to update some centers DB'sand on the center i need to run some Quality check on the dataNow it's beeing fixed by a dll so my solution was to change the dllto an exe but my mistake i tried to check how to do it and my check was on the calc.exeand not somthing with out interface |
|
|
|
|
|
|
Run an exe from Store proc