Replication has changed order in my table
Posted on 2010-11-09
For transactional replication to work you have to have a primary key.
Before transactional replication was set up I had a table called dbo.Area which had columns AreaID(int,not null) and AreaDescription(char(15),null) this was result when I did a select
Select * from dbo.Area;
1 100 Coke Side
2 200 Pusher Side
To make transactional replication work I added a UniqueGuid(PK, uniqueidentifier, not null). Now when I do the same select I am getting
1 200 Coke Side
2 100 Pusher Side
This is causing issues in our production environment. How do I get the descending order back?
Thank you for your help