Triggers

External Article

Avoid External Dependencies in SQL Server Triggers

  • Article

I sometimes want to perform auditing or other actions in a trigger based on some criteria. More specifically, there are a few cases that may warrant an e-mail; for example, if a web sale takes place that requires custom or overnight shipping and handling. It is tempting to just add code to the trigger that sends an e-mail when these criteria are met. But this can be problematic for two reasons: (1) your users are waiting for that processing to occur, and (2) if you can't send the e-mail, how do you decide whether or not to roll back the transaction, and how do you bring the problem to the attention of the administrator?

2011-02-14

2,819 reads

Blogs

The Importance of Patch Management to Avoid Downtime

By

A recent Microsoft outage caused by a bad patch pushed out to Windows instances...

Friday Flyway Tips–Comparison Defaults

By

One of the little details that I find matter more and more in enterprises...

A New Word: Solysium

By

solysium – n. the unhinged delirium of being alone for an extended period of...

Read the latest Blogs

Forums

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers