Sending messages to VB from SQL 2000 using triggers

[ppynrde]

Is it possible to have SQL Server send messages to Visual Basic when a table update trigger fires. I need to inform a user on a client machine when some base data changes so that they can refresh the data on their machine.

Any help would be most appreciated.

 

[mowog74]

I don't know of any easy way for sql server to send a message to a vb app.

I would have your trigger(s) update a single "last updated datetime" value in a table somewhere, and then have your app check this value periodically to see if its last refresh is stale.