these tables with the composite PK are lookup tables. I was thinking about just leaving them as standalone tables(no FK relationship to data tables).

suggestions?

what are the rules here?

work arounds?

so what can I do?

i need the composite key and I need a FK to it?

like going from a OLTP model to a de-normalized version of it.

I will be doing an Active\Passive setup.

I will be replicating this.

(sql server 2000 transactional replication.)

so I will be setting this collation at the database level. based on the information here, which collation do I choose from the "Collation Name" in E.M. when creating a...

we want a fully lingual database. no limit on # of languages.

What should this look like when its installed and setup?

(instances installed, etc)