Solved: had to set CopyAllObjects = $false, and enumerate each of the object categories and set them to $true.

Boooo: I added RAISERROR ('test', 11' 1) at the end of the trigger (10 is converted to 0 by SQL Server -- See Erland Sommerskog's website http://www.sommarskog.se/error-handling-I.html#@@error)

The Insert occurs successfully,...

If possible, I prefer to avoid triggers altogether.

Having said that, on tables where business rules can be enforced using DRI and constraints, I use them for auditing.

However, my developers...

Thanks Jack,

That's what I was afraid of.

Ah well, it needs doing, so....

P

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.