September 7, 2008 at 1:43 pm
Hi,
I'm developing a 24x7 public services application, a TeleBanking Application which requires Web Services Integration for which I've had to develop a VB.NET Windows App with out a UI.
The executable would take Inputs from an SQL Server Table when a record gets Inserted or Updated and perform a number of tasks like posting Web Services query, updating local SQL Express 2005 Server Database and creating Dynamic Voice Files for being rendered on the Interactive Voice Response System.
My requirement is to have the executable run every time a record in the table gets affected.
I've had to avoid using Threads as I wasn't sure of the Database Poll method and spawning of a number of Threads as the number of records in the table.
Can anyone help me?
I need a way to handle this in my System.
Thanks
Arun
September 8, 2008 at 8:18 am
Is the executable something that could be done by a CLR proc called by a trigger? I think that can be done, but I'm not sure how well it works. That would certainly be the easiest way to do something every time anything happens to a row of data.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply