If you want, send both files as HTML to us and I'll have someone dig through the differences. Maybe we can figure out what email systems are doing.

Send to the...

I'd say avoid all large, generic ERP programs. I think they all suck. I worked for JD Edwards and Peoplesoft, both of which were POS products in my mind.

So we send the same HTML that you get on the web to your client. In terms of how it renders, I know that my webmail (GoDaddy), and GMail, is...

Where/how are you reading mails?

Any large queries, hitting lots of data, can use tempdb for the intermediate process.

This is a spot count. If you want to know the max, you need to keep track of this over time, grabbing the total count at various times.

The job you are deleting is linked to a maintenance plan. Clear the maintenance plan first.

My view is the PKs, FKs, are based on business rules. You can't define an OrderItem to be definitely linked to an Order without a business rule. So if the...

You really need to post more information about what you are doing, how, the code, and the exact error message.

Please don't assume the title of your post is part of...

Wet Fart, I think you're responding to DJackson 22568. His name is in bold. Grasshopper is the level.

It sounds like you've had a bad experience. I don't think that...

Did not know that, though I've avoided cascading deletes and updates for years.

Does anyone use this?

That's a fair response, Paul, and what I'd expect. I think the big issue is that the built in tool is good enough, even if it's not that great. ...

You'd have to move the child, disable the FK, or drop the FK. My guess is they are moving the child to another record, or a holder record.

Or they don't...

Why not? Just curious. If it really helps you, is it...

I don't think they're substituting diseases. As I read it, they don't differentiate down when the sample size is small, so you don't get Diabetes I or II for small...