Accedi
 
HomeLibraryRisorseFormazioneDownloadSupportoCommunityForumBlog
Risorse per professionisti IT >
> 
> 
Store Procedure and Transaction Replication - Working at the same time

Con risposta Store Procedure and Transaction Replication - Working at the same time

  • mercoledì 2 maggio 2012 12:23
     
     
    Registrati per votare
    0

    Dear All

    SQL Server 2008

    We have a rather large 11TB Publication replicating to two subscribers using transactional replication. This also replicates a table with over 8,000,000,000 records (yes I got the commars correct) :)

    To fix a long term bug we wish to modify about 9% for these records (about 720,000,000) records.

    In the past whenever we have done any work that gives a large transaction (i.e. update 10,000,000 records) it causes our transaction replication publication to halt as it attempts to execute the batch, this causes replication delays and a rather unhappy client.

    So we have an idea of creating a store procedure and replicating that.

    This Store Procedure will be updating a table that is already marked for transactional replication. My understanding is if this Store Procedure is executed and replicated, it will  not mark the records changed as Transactional Replication, but for Store Procedure replication, bearing in mind we have Transaction Replication (Insert, Update and deletes) on the same table.

    Can anyone please confirm if this statement is true ?

    Thank you

     

Tutte le risposte