They would be non clustered...

For info, here is the full query with the bit in bold the section which causes the job to fail

--== This is for SQL 2005 and higher. ==--

--== We will...

infact looking again at your post you dont even need a HAVING clause. you just need the max

select Max(auditDate) from tblAudit_AuditSchedule where agentNumber = '54321'

if you need it per...

You need to remove the auditdate from the grouping and in your HAVING clause you need max(auditdate) = xxxx (depends on what you want it to equal?)

We use a product called OpManager http://www.manageengine.com/network-monitoring/

Fantastic product that does all the server monitoring you would expect from an enterprise level product. Granted its not free, or...

Is your issue that you cant start database mail? Or that you think its started but are still receiving the message you posted?

If you cant start it...

Specifically for your SQL boxes or just all servers on your network regardless of SQL instances?

The readtrace command line tool which comes with the RML utilites fires up a reporter GUI at the end of it reading the trace files which is almost identical to...

You are correct in saying they are produced by the SQL RML utilities. Normally used for performance testing etc on a new server.

They are essentially like trace files which...

What format is the file in? Is it just one continuous string of email addresses? (i assume it is as your asking about string splitters)

Check out Adam Machanic's WhoIsActive procedure. Its fantastic for this sort of thing and comes with excellent documentation on multiple uses of it

http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

Hope there isn't any issues with linking...

Im assuming by your use of the word "workgroup" that you mean your not on a domain, and not the sql version your using?

If so, you need to create a...

FYI its SQL 2k8 R2 Standard at publisher and 2k8 Workgroup on Subscriber. This also appears to be the only article in the whole publication that has this issue.

I...

is the database replicated?

I know a very similar error comes up on replicated databases and you have to be a dbo to be able to make ddl changes.

Wow, large subject area there. Maybe start with a couple of questions about the key things you want to find out about. The articles on the left there is probably...