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...

Kenneth,

shameless plug, but my other company, End to End Training (www.endtoendtraining.com) does some in Orlando.

You might want to put a note in the BI forums here on the site...

bold or brash?

Or a busy one