Vince,

If this database is a 'replica' in a replication set ( or
group of replication databases ) you can divorce it and make
it 'designable' again if you aren't going to intermingle the
changes with the other databases ever again. Otherwise you
want to do any design changes with the designated 'Design
Master' database of the replication group.

If you are sure that this one will never want to talk to the
others again, or if you want to make it the new 'Design
Master', the simplest way is just to turn the replica into a
new design master. This will not strip out all of the
replication specific fields such as the GUID autonumber
fields, but it will let you operate it on it's own with no
problem. Later, you could even create a new replica set if
you choose, although you will have a bit of a 'missing
ghost' problem with the original family of replicas that you
never synch with again.

I don't have a replicated DB to play with at the moment, but
as I recall you go to Tools, Replication and you will find
an option to Recover Design Master or something similar to
that. The wizard should prompt you through the procedure.

Good Luck,

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________