sql server replication: Sort Order in Merge Replication -- sql server replication

Sort Order in Merge Replication

Jim
6/30/2003 8:16:39 AM

sql server replication:

I created a merge replication with a push subscription. I
have a setup table in the DB that only had one field in it
and it was sorted in Ascending. After I turned on
Replication the sort on Status is no longer ascending
alphabetically. Replication added rowGuid and indexed
that as well. I am thinking that is the reason my sort on
status is now malfunctioning. Is there a way to get the
sort back on the original column?

Thanks,

Re: Sort Order in Merge Replication

SQL Server Development Team [MSFT]
7/1/2003 3:23:09 PM

Solution 1:
Drop the publication and the rowguid col and then create a cluster index on
the table field, then re-dreate the publication
Solution 2:
Change the rowguid index as non-cluster and and a cluster index in the table
field

Thanks,
Damián

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]