Name: Anonymous 2007-03-22 6:17 ID:zDtY+At1
I'd like to set up a mechanism whereby my client programs are notified when data has changed in the SQL server so they can update their displays.
I don't want to poll regularly as that means a lot of unnecessary queries. Ideally I'd like the SQL Server to send something down the existing connection to notify just after the data has changed. Is there a way to have a query block until an event happens, like an SQL equivalent to the Win32 API's WaitForMultipleObjects?
Any ideas? I am using Microsoft's SQL Server 2000.
I don't want to poll regularly as that means a lot of unnecessary queries. Ideally I'd like the SQL Server to send something down the existing connection to notify just after the data has changed. Is there a way to have a query block until an event happens, like an SQL equivalent to the Win32 API's WaitForMultipleObjects?
Any ideas? I am using Microsoft's SQL Server 2000.