Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2012-10-10 : 02:33:25
|
| Hi, I am working on publishing and subscribing. I published a database and subscribed it. Now when start testing on my subscribed database i am getting primary key violation. I know its because the primary key id range is not correct. But dont know how can I correct it.Can anyone help me how can I do it. I am using sqlserver 2000 and sql server 2005.Thanks in advance |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-10-10 : 02:56:46
|
What are you doing when you say "testing on my subscribed database "?
Too old to Rock'n'Roll too young to die. |
 |
|
|
shobhaaradhya
Starting Member
37 Posts |
Posted - 2012-10-10 : 03:17:02
|
I am trying to insert data to few tables. quote:
Originally posted by webfred
What are you doing when you say "testing on my subscribed database "?
Too old to Rock'n'Roll too young to die.
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-10-10 : 03:42:23
|
So you have a transactional replication and you can make your changes only on the publisher side unless you have a merge replication.
Too old to Rock'n'Roll too young to die. |
|
|
|
shobhaaradhya
Starting Member
37 Posts |
Posted - 2012-10-10 : 04:08:51
|
Hi, Thanks for a quick reply. Can you suggest me some good links where I can get info on this. PleaseThanks,quote:
Originally posted by webfred
So you have a transactional replication and you can make your changes only on the publisher side unless you have a merge replication.
Too old to Rock'n'Roll too young to die.
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Primary key violation when database is subscribed