MSSQL DDL - collate, not for replication

[awolfe@m]

Some columns in a model need to be case insensitive, while others are case-sensitive.  Is it possible to allow the collation of an attribute for a table to be specified?  Is there a tagged value already available that I overlooked?

Is it possible to specify a "not for replication" option on associations between tables that are foreign keys?  The physical database replicates most tables for reporting, but the FKs shouldn't be enforced during replication.

Please let me know either of these settings is already possible, or if they could be added to the wish list.

Thanks,

Andy