Well wouldn't know any other way to "directly connect" other than the linked server.

I wasn't really questioning if it was or wasn't a distributed transaction but more specifically...

Thanks but I am not using a star schema or doing dimensional modeling. 🙂 Much appreciated though... I've actually met Ralph Kimball and gotten his autograph... hehe. 😉 ...

So, wherever you go...there you are? 😀 Hehe, sorry couldn't resist. 🙂

I will also add that doing your conceptual design, logical design and physical design and actually drawing it out can and will help you a ton. When you do...

Thanks! Yes, I was just simplifying my response but yup totally agree with you.

Unfortunately we cannot alter request table to include the description as this would impact...

Thank you appreciate the feedback!

Thanks, so my idea of adding an effective_date column and then doing the if today is greater than or equal to the effective_date use X row otherwise use the older...

Ah thank you! I think that's the piece I need...that may very well be why it broke. The Network guy removed 2.0 as well.

And I shouldn't have used...

Ah, now that is an interesting concept..... very interesting indeed! Thank you for that... I am going to mull that over in my brain for a while!

Hmmmm, that is indeed interesting. The part about them being extensions to 2.0 ... perhaps that is my culprit.

Right, I agree and thank you for the reference... but I work for the Gov't and they are being mandated to remove depricated versions of software from machines. So,...

We...

GilaMonster (4/2/2013)

Why not?

Comparability level doesn't disable new features, it just changes...

Hmmm no not really. 🙁 Unless I just don't understand what I'm reading. I don't understand how the .NET version impacts SQL Server and why upgrading to 3.5...

No they are not on the same network and there is no VPN. When you say get a "secure link between the 2" what are you referring to?

I think...