stevewes (9/23/2013)
Hi Sean,That is great info, yeah the info needs to be real time our Help desk ticketing application gets lots of email request into a particular table and seem to break when it gets to 100 !! so it's so we can notify the Help desk Admin guy before it does break. I think a Trigger probably is best, the SendNoticationsHere do I then put in "email address" ?? is there any other thing I need to check? I am using SQL 2005 Enterprise 32bit.
Many THX
Steven
That was very rough sketch pseudocode. You will need to create and send an email there.
Here is a good place to start on that. http://technet.microsoft.com/en-us/library/ms190307%28v=sql.90%29.aspx
That will show you how to create the email and send it. You will also have to enable that feature. It explains that in the article as well. Let me know how you get along.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/