Identity Doubt

• Jerish

  Old Hand

  Points: 317

  More actions

  July 29, 2002 at 11:05 pm

  #101210

  Hi Guys,

  We are having the plan to make a snapshot replication . We are having two servers. To increase the performance , we are using two servers. One is for administration purpose and another is for normal user.

  Our plan is just replicate the data which are needed by the user from the administrative server and dump it into user server. In user server we don't allow any insertion/updation of the replicated table.

  So we are having the plan to not include the IDENTITY With NOT FOR REPLICATION option.

  Will it make any problem ?

  Please advice.

  Thanks

  Jerish

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 30, 2002 at 4:39 am

  #433618

  Doesnt matter at all with snapshot.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn