When the trigger fires for the update it takes the data of the updated row and constructs a control string which it passes to the xp. The xp then passes this...

Polling is not a viable option as this would be too slow, the VB app in the architecture outlined below needs to know immediately about an insert. The current problem is that...

Did not know that an execution of a job would run out of process in another SPID - if this is the case then this sounds like a viable solution....

This would be far to slow, i need real time event processing from the update - the maximum delay time I could have from the update to the external vb...

I do not think that would work because you would still have to wait for the job to complete before the control of execution would return to the trigger. I...

Hi,

I think the BIT option would be faster, not sure by how much though.

When comparing two BITs you are literally comparing at a Bit level - value A (0...

Thanks, that does the job nicely.

Hi Andy

I have no second select, the actual data that this will be performed on is 800,000 records long. Therfore i return a reference to the test1 tables location, so...

Hi,

Yes it does, when I tried it I must of read my results wrong.

Sorry for posting such an inane question.

Alan

Thanks Chris,

It does work and it is nice and simple. However I am developing a navigation clint for a 800,000 record table so I do not think this is efficient...