I have created a replicated database, using a transactional replication, but are having some difficulty understanding some aspects of the process of replication.
In my publication of the datadase, I have includes tables and store procedures, as these do tend to get altered. However, when they are altered, the replication fails, or the changes to the tables and store sprocedures do not copy across.
How does the replicated database tables and store procedures get updated everytime there is a change on the live database?
Is this a short fall in SQL 7.0?
Does the snap short agent updated the replicated database or do I need to update the tables and store procedures manually?
Any help would be very welcome.
In my publication of the datadase, I have includes tables and store procedures, as these do tend to get altered. However, when they are altered, the replication fails, or the changes to the tables and store sprocedures do not copy across.
How does the replicated database tables and store procedures get updated everytime there is a change on the live database?
Is this a short fall in SQL 7.0?
Does the snap short agent updated the replicated database or do I need to update the tables and store procedures manually?
Any help would be very welcome.
