Hi all
Im having a real strange problem i havent seen before. Ive got merge replication set up between two SQL 2005 machines. Ive just refreshed our UAT environment to match live, so restored the publisher and subscriber databases, configured replication and pushed out the snapshot. Ive done a SQL complare to see what's different and for some reason there are a couple of tables missing some non-clustered indexes. The indexes should be replicating from Prod - the option is set in the publication properties to do this.
Any ideas why this would be happening?? Works fine with some of the indexes but not others (on the same table). Never seen this before!!
Thanks,
Di
Im having a real strange problem i havent seen before. Ive got merge replication set up between two SQL 2005 machines. Ive just refreshed our UAT environment to match live, so restored the publisher and subscriber databases, configured replication and pushed out the snapshot. Ive done a SQL complare to see what's different and for some reason there are a couple of tables missing some non-clustered indexes. The indexes should be replicating from Prod - the option is set in the publication properties to do this.
Any ideas why this would be happening?? Works fine with some of the indexes but not others (on the same table). Never seen this before!!
Thanks,
Di