I need a trigger to fire an email from my database when a column is update in my order table to dispatched.
The email is not meant to be human readable.
It needs to pull the email address for the relevant customer from the customers table as the send to address.
It also needs to pull a code from the shipping table.
The email would look somethi...
Skills: microsoft sql server programming, microsoft sql server administration, sql programming