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 - 2005-08-11 : 08:19:23
|
| javier writes "hi my name is javier from spain and this is my hard question (i hope so):¿can i call from a stored procedure an external application such as calc.exe or winword.exe so that it executes?i tried to do it with xp_cmdshell but it doesn't workthank you very much" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-11 : 08:20:30
|
| You should handle this in your presentation layerWhy do you want to do this in SQL Server?MadhivananFailing to plan is Planning to fail |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-11 : 08:21:37
|
| You cannot use xp_cmdshell to call a program that requires user interaction, and/or does not automatically terminate after it runs. Winword and Calc do not meet these restrictions, and trying to call them this way could lock up your SQL Server. xp_cmdshell is intended to be used with DOS commands like copy, dir, rename, etc. |
|
|
|
|
|
|
calling an exe from sql