By Wade Wilbur For low-volume databases, those that are
predominantly read and not written to, or database tables that
are designed to not be updated or only updated under rare
circumstances, a DBA or developer may be interested in being
notified whenever the data in a particular table is modified. Or
you may have certain records in a table that are assigned to a
particular user and, upon that record being updated, that user
should be notified of the change. While this sort of logic can
be implemented at the code level, Microsoft SQL Server has all
of the technologies needed to achieve this aim built directly
into it. Triggers can be used to perform some action when data
is inserted, updated, or deleted from a table, and Microsoft SQL
Server's extended stored procedure can be invoked to send an
email to one or more recipients. Combining triggers with
xp_sendmail provides a means for alerting specified users via
email when the data in a particular table is modified. The
purpose of this article is to demonstrat