replication and identity

  • 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

  • Also I should add that this is not a dedicated stand by server, just another production one with different databases. The database is only 10Mb.To implement the switch over, all I would do is point the web app to the standby database.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply