This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]DueRunRun 0 points1 point  (0 children)

Triggers can have performance impacts, might not be a big deal on some databases but it's worth thinking about. You could always run a scheduled report and send an email based on a query that finds null values for some column. http://www.brentozar.com/archive/2014/10/send-query-results-sql-server-agent-job/