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 |
|
SQLMonkey
Starting Member
4 Posts |
 Posted - 2007-07-24 : 07:41:38
|
| Hi,We had a healthy 2-way merge replication set up with a SQL 2005 publisher/distributor and a SQL 2000 subscriber which had been running for about a week. I re-created the publication so I could add automatic identity range management to an article. I sucessfully re-created a push subscription to a SQL 2005 subscriber but when I tried to create one to the same SQL 2000 machine that had been quite happy a few hours earlier, I kept getting this error during initialization: "bulk data stream was incorrectly specified as sorted". Nothing much has changed as far as I can see. Can anyone give me some pointers?Thanks,Pete |
|
|
SatyaSKJ
Starting Member
46 Posts |
Posted - 2007-07-25 : 07:02:06
|
| Make sure the publisher and subscriber do have similar set of collations on the tables and columns that are involved in replication.Satya SKJSQL Server MVPhttp://www.sqlserver-qa.net |
 |
|
|
SQLMonkey
Starting Member
4 Posts |
Posted - 2007-07-26 : 10:05:54
|
| Thanks for your response.Actually the collations were different - SQL_Latin1_General_CP1_CI_AS on one and Latin1_General_CI_AS on the other. I did change the collation after reading of a similar problem on a Microsoft forum and the problem did go away. However, what strikes me as odd is that it was working before I changed the identity management settings. I certainly hadn't changed the collation. I'd be interested if anyone could shed some light on this, for future reference, but it's no longer urgent.Pete |
|
|
|
|
|
|
Error on replication initialization