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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-03 : 08:33:07
|
| KIOKUPS writes "is there a way in sql stored procedures that allows running an executable file/appliction." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-09-03 : 08:35:20
|
| There is, it's called xp_cmdshell. BUT, it will NOT let you run regular executables like Word, Excel, or something that opens a web page. The only commands that work are command-line utilities like copy, dir, etc., things that terminate immediately after running and do not require user interaction. If you try to run something like Word from xp_cmdshell you'll lock up your SQL Server. |
 |
|
|
|
|
|
running other applictions using sql stored procs