Terry Chilvers (terry.chilvers@ntlworld.com) writes:
> Is it possible to notify a connected client application when specific
> events occur in SQL-Server? For example, if data is changed in a
> particular table, I would like a trigger to execute for the change, and
> for a connected application to be alerted to the fact that something had
> changed, rather than polling certain tables.

There is no built-in support. You could use a trigger that calls an
extended stored procedure (XP) or an OLE object that performs the
notification. The notification should probably not contain the data itself,
but instruct the client how to get the data.

But there are a couple of caveats writing XPs and calling them from
triggers, so be careful.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp