When upgrading a SQL Server 2005 database which has replicated stored procedures and views, the DDT throws errors messages. I don't know if you are dropping and recreating them but is it possible to alter them instead?

On a similar note, it would be useful if the DDT didn't drop the indexes added to the database by SQL Server for merge replication. These indexes would never be in the DDT model and are used only by replication. Replication will work without them but performance drops - we have a replicated system with around 800 databases and we can't afford the indexes to be dropped.

Thanks,

Aaron