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-03-18 : 08:21:30
|
| Krishna writes "Hi, I need a help from you. Whenever a change happens to one my table, i need to create an XML from the table and send it to a remote system. I found that sp_makewebtask procedure creates line breaks after every 2033 characters. So i created a vb application to dynamically retrieve the xml from the table and send it the destination as XMLDOM object. For this i used xp_cmdshell to call the VB application. I put this call in the table trigger. But i found xp_cmdshell works synchronously. I need a better solution for this scenario.Looking forward for your helps" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-18 : 08:23:53
|
| Create a job that runs the VB executable as a CmdExec step. You can then:EXECUTE msdb..sp_start_job 'myJob'The result is the same, and the job will run independently from the rest of the batch. |
 |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2004-03-18 : 08:44:27
|
| Another way might be to schedule a task in Windows to run the VB app.--Frankhttp://www.insidesql.de |
|
|
|
|
|
|
Better solution to xp_cmdshell