try a trigger on inserts of sysservers table in the master db. 

What account are the SQL and SQL Agent services running under?  If not a domain user, then you will need to execute the xp_startmail stored procedure to start the mail...

Just curious why you would need to do this?  You create the temp table through code, so you should know what the columns in it are. 

Sounds like you need a cursor where your SQL statement would be:

Select n.something, count(*) as Number

from...

group by n.something

This will get you all groups that have records you are tyring to...

A Cursor and fetch relative command may work best, especially if you may be sorting the records by different fields.

For example:

create spRecordNo @rcdno int

declare @CustId varchar(20)

Declare tmpCursor Dynamic for (Select...

Where convert(varchar(50),ContractDate,101) = convert(varchar(50),getdate(),101)