I have the following code installed on my database.
Create Trigger CFXSOUpdate
On SalesOrder
For Update
AS
If Update(SOM_DefaultRequiredDate) or Update(SOM_DefaultShipMethod)
Declare @Body varchar (100)
Set @Body= 'The Required Date or Ship Method has been changed'
Exec master..xp_sendmail
@recipients = 'ARaedeke@Tri-Optic.com',
@subject = 'Sales Order Change',
@message = '@Body'
The trigger fires when the fields are updated, but the email message only has the word
@body in it. No sign of the message I intend to send.
Thanks for the help,
Arlin
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies