I am going to replicate a Database in master server to another server for reporting purpose. Both of two servers are using MSSQL 2005 Standard Edt and I use Transaction mode replication. The problem is, there are quite a lot of columns having "Identity" property, which gives the errors when replicate the data.
I am not able to change the Database schema. I could not ignore the replication for those identity columns because they are primary keys in the Database as well. Is it possible to replicate the value of identity column to subscriber? Or is there any script which can disable the "Identity" property for all of the tables in the Database?