<div>
delboy10: <br />
This old question needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;For information on your options, please click here-&gt; <a href="http:/help/closing.jsp#1" rel="ugc">http:/help/closing.jsp#1</a>&nbsp;<br />
EXPERTS:<br />
Post your closing recommendations! &nbsp;No comment means you don't care.
</div>


delboy10:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 [http:/help/closing.jsp#1] 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

<div>
No comment has been added to this question in more than 268 days, so it is now classified as abandoned.<br />
<br />
I will leave the following recommendation for this question in the Cleanup topic area:<br />
&nbsp; &nbsp;Accept: angelIII <a href="http:#8135265" rel="ugc">http:#8135265</a><br />
<br />
Any objections should be posted here in the next 4 days. After that time, the question will be closed. <br />
<br />
monosodiumg<br />
EE Cleanup Volunteer<br />

</div>


No comment has been added to this question in more than 268 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: angelIII http:#8135265 [http:#8135265]

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

monosodiumg
EE Cleanup Volunteer


<div>
<div class="content wysiwyg-content">
I need to write a trigger that will fire off an email if a particular field value is changed to 1.<br />
<br />
Any ideas?
</div>
</div>


I need to write a trigger that will fire off an email if a particular field value is changed to 1.

Any ideas?

write email firing trigger

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.