Congratulations Charles! 35 years is something to be proud of.

That's a classic MS interview question on the web. Lots of possibilities, can't fall through, strength in the circle. Personally I like the "it fits" answer.

I'm not sure that abstract...

First I wouldn't prefix things. Never know what might happen here and then you're messed up. I'd say DiaryID, EngineerID, etc. That way someone isn't asking if FK_Engineer matches to...

Not an MDX guy, but does this help?

http://www.databasejournal.com/features/mssql/article.php/10894_2168911_3

Joel's advice should work. If you have separate connections, you can connect them with an "On completion" workflow as well if you want to sequence them

I've seen similar things with ODBC as well. OLEDB, or better yet, ADO, should fix this.

Good advice above. There are two thoughts from most people: Use identity because it's easy, small, etc. as the PK, or use the natural key, meaning the fields that uniquely...

Haven't seen that, but there are possibilities for what's wrong. WITH CHECK in the view definition, data changes, etc.

Can you post some code? Is there looping in the view?

You need the DTC service to be running and I remember some trick with AD security to be sure that both sides can correctly communicate with each other. The distributed...

Don't think so. Everything I've seen asks for a restart.

xp_smtpmail, by Gert Drapers works great. He's now at MS, but many people have been happy with that.

If you script out the table, you can see the collation.

I'd maybe give a try to bcp out the table, just to be sure it's intact. That's usually been a...

The problem is software changes much quicker than planes, so I'm not sure how well certification measures up. I'm still voting for more narrow certs. The problem with an MCSE...

What kind of job and where in Denver

I think that the outlines for the exam are a good broad based set of skills. However the exams don't test your ability to do them, other than the 431...