Ah sorry, the errors (copied from another post):

Msg 5110, Level 16, State 2, Line 3

The file "\\web-server6\FreeAgent\Backups\SQLtest\Data\Test_COR_Online.mdf" is on a network path that is not supported for database files.

Msg 3156,...

Fount it.

I think he was using general case, as in, all HTML needs to be between <sometag> (open) and </sometag> (close)

Try this as message text:

This is the first line.

This is the...

Thanks Sergiy!

It works (at least with xp_smtp_sendmail)!!!

Been trying to get CR-LF in emails for years!!!!

So I had one of the developers write a little .net app which queries AD for what I need and outputs it to a .csv in about 20 seconds --...

Thanks Brian!

OK, I'm sold. Where could I find such scripts?

Well, if I can't find a way to do from the server, I'll look into an outside solution.

"Your AD administrators will thank you. :)"

Why do you say that?

In fact, it was an AD replication thing. Took waaaay longer than expected.

Hi Seth,

Thanks for having a look. If I understand your proposal, it's to break down the single into two. That means I'm maintaining two versions of the function, while...

SELECT CONVERT(VARCHAR, GetDate(), 101) + ' ' + CONVERT(VARCHAR, GetDate(), 114)

See CONVERT in BOL.

So, my guess is that it's a compilation thing. However, the server's been running for 2 months, and the problem only began manifesting itself for one of two users today...

Thanks for your help Gail.

I'll look into the msdb rebuild option.

P

Hi Gail,

Yes, msdb was restored from a backup made from a server configured as

SQL Latin1_General_CP1_CI_AS.

(We upgraded the OS on the server, and did a full re-install of SQL. This...

Hi Gail,

Good call, the msdb and tempdb do not have the same collations.

This is the sproc that's getting called every 20 secs.

EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

Soooo, what are some possible solutions?

P