I'm sure this has all been covered before.....
I am trying to implement a sql 2000 standby server using transactional replication. The standby tables are stripped of their primary key and the identity constraint.
Therefore I can't use it as a standby server without going through each table and adding the primary key and identity. I have read you cannot change a column with t-sql to identity, so anyone know the best way I can implement this?
thanks