Transactioanal replication



How to avoid removing primary key on subscriber's database, i mean when i
configure Transactioanal replication from one server to another with same
database, (publisher to subscriber) at subscriber's database all primary
keys disappear, WHY ??????????????????

I have primary key like identity and regular, identity keys rae not for
replication, however it removes all kind of keys.

Any suggestions appreciated.

Thanks

--
Message posted via http://www.sqlmonster.com
.



Relevant Pages

  • Re: Key attributes with list values was Re: What are the differences ...KEY
    ... Jane Harper is married. ... And a constraint that states that single people cannot become divorced. ... database, or users, for that matter, to distinguish between them. ... That's the whole point of keys. ...
    (comp.databases.theory)
  • Re: Pin generation algorithm question
    ... the keys would be a big ... Suppose that we have a database that contains all valid numbers, ... load among several servers that all need access to this database. ... So the only real problem is which systems are accessing this crypto box. ...
    (sci.crypt)
  • Re: Database design, Keys and some other things
    ... >> Or 'the database has no opinion as what Donald Trump's e-mail address might ... some keys can be wrong or a data can ... Meaning is not related to just one number. ... > is concerned a VIN is not a surrogate key, ...
    (comp.databases.theory)
  • Re: FOREIGN KEY CONSTRAINTS
    ... veracity of your database application. ... keys vs. surrogate keys are available for your reading pleasure. ... surrogate key and a unique index that doesn't allow NULLs on the natural key, ... The EMPID primary key in the employees table remains ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Key attributes with list values was Re: What are the differences ...KEY
    ... database, or users, for that matter, to distinguish between them. ... That's the whole point of keys. ... But that is true of any constraint. ... keys can change, then either updates must be singular, that is, must affect ...
    (comp.databases.theory)

Loading