Hi Thanks for the swift response, that did get rid of my syntax error thanks.:-)

cheers will take a look

Hi where would the IF condition be best placed as I really don't want a full mailbox..

Thanks

Steve.

Hi Sean, please can you check...

CREATE TRIGGER tgr_SM7EmailQ

ON TBL_EVENTOUTm1

AFTER INSERT

AS

BEGIN

SELECT COUNT(*) AS EMAILQFULL, [evtype]

FROM EVENTOUTM1

GROUP BY [evtype]

HAVING COUNT(*)>= 90

EXEC msdb.dbo.sp_send_dbmail @profile_name='profile name',@subject='Email Q Rows Filling up', @recipients ='email address',@body =...

Hi Sean,

I have managed to get the query working and also have setup DB Mail and the Query now mails me if the rows are greater than 90 so all...

Many Thanks Sean,

I will pick this up again tomorrow............

luckily I have a test server to try it out on will read the article and go from there. I have created...

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...

yeah this is a great help many thanks!!!

next step is to I suppose create a Job with the SQL query in as a step the next step is how do...

Hi, how do I do this ?

my select statement goes something like this

Select count(*) AS EMAILQFULL,column name from tablename

group by column name

this returns the number of rows in the...