Okay, taking a minimalist approach, I started out by installing just the SQL Server 10.0 Native Client on my Server 2003 machine (that's package sqlncli.msi). That turned out to...

Thank you. I don't know much about all these packages, so I'm hoping that nothing I install will "break" my current installation. Of course, this is just in...

Yes, it is. However, I'm investigating whether installing some utilities from the site below will help. They indicate that they're backward compatible, and will enable my SS 2000...

Hmm - I'm trying to connect and I can't get anywhere. I've got the server identified properly and the SQL Server authentication correct, but I keep getting the error...

Very helpful - I learned some things I didn't know (and which I'd been doing wrong ) - but now I know how...

Good, terse explanation.

The only issue I'd have with it is the use of the terminology "Parent" and "Child" to describe the relationship between the primary key and the foreign key(s)...