I need the SQL Server to notify the VB Clients in real time of any changes and therefore timer type polling will not do. The process has to be continous. I believe spawning a continous thread in VB is not the best way. Do you have any suggestions on how to achieve such a goal? (I have heard of two technologies so far DCOM + MTS or Extended Stored Procedures + ActiveX)

Cheers for you help