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 |
|
satishk
Starting Member
39 Posts |
 Posted - 2007-05-29 : 08:27:23
|
| Hi ,Plz help me.The scenario is as followsI have a db on sql server 2005.I have replicated the db on sql server 2000.All the data counts seems to be correct.But the online websites are not able to execute queries generating error(Microsoft OLE DB Provider for sql server error '80040e21'.Multiple step OLE DB operation generated errors.Check each OLE DB status value,if available.No work was done.)Same web aspcode is working for other db (which were replicated from sql server 2000).Also one more thing that was observed is as follows:1)Prmary key was replicated for some of the tables.When primary keys were removed manually report executed fine.Thanks in advanceSatish |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-05-29 : 12:11:51
|
| Not sure if I understand your question but replication can only be done for tables that have primary keys. Are the errors coming from the subscriber or the publisher?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-29 : 13:52:32
|
| Which replication do you use? |
|
|
|
|
|
|
Primary key columns issues in replication