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-10 : 08:50:52
|
| Pratik writes "I am working on project. I need to call external servlet (http://servername/servlet)when new record will be inserted in SQL server's (SQL server 2000 v8) table. I believe TRIGGER will solve this issue but I dont know how to call this servlet from inside trigger. If this is not possible then I can put .class file of that Java application on SQL server to make life easy.Before posting this question I tried to find answer from many sites but I did not get any answer.Any advise will be appriciated.Thanks in advance." |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-09-10 : 09:25:09
|
| It can be done. Search this site for "XMLHTTP"But this would be much better handled in another tier. Perhaps queue the calls and perform them outside of the db. Especially when considering making this call from a trigger. |
 |
|
|
|
|
|
call http servlet from trigger