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 - 2001-01-04 : 18:03:56
|
Jason writes "Hey there, SQL Guru!
I have an VB App I wrote that I want triggered whenever a couple tables in by database are changed... I tried putting the execute statement in a .bat file and using xp_cmdshell in my trigger, but whenever it runs, the database just freezes up and nothing happens. I know the VB App is working correctly because I run the .bat file in a SQL Job scheduled to run every hour (just for debugging). Is there any way to run a program from a stored procedure, without calling up the Command Shell?
Thanks for your time!
Sincerely,
Jason" |
|
|
|
|
|
Running an EXE from an Stored Procedure...