Hopefully they're the same thing

I think that most comments are what you intend the code to do, but not explaining what a knowledgable...

I think the recent convictions in the Enron and Qwest cases have done more to help prevent fraud. Enron was an anomoly. A big CPA firm colluding to the extent...

I did the same company twice in grad school and ended up working for them, but I also did a couple in high school at different places (got lucky there).

I'd...

First of all, lots of companies promote the best performer to manage under the idea that if they are good at one job, they'll be good at another. Also that...

I guess I'd think helper tables might be a design weakness. I'd probably counter and ask them if there was something particular they needed. Lots of places I'm weak now...

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.