Welcome to Sign in | Help

Re: Sincronizare SQLServer Express

  •  08-24-2007, 8:36 AM

    Re: Sincronizare SQLServer Express

    Am reinnoit brokeru pe ambele baze comenzile

    select * from sys.transmission_queue

    SELECT CAST(message_body AS XML), * FROM replicare

    rulatre pe amblele baze sender si receiver nu returneaza nimic.

    Cred ca nu se activeaza pe reciever procedura cand se insereaza un mesaj in coada.

    Am definit asa coada pe receptor

    CREATE QUEUE [dbo].[replicare] WITH STATUS = ON , RETENTION = OFF , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [dbo].[repl_insert] , MAX_QUEUE_READERS = 5 , EXECUTE AS N'dbo' ) ON [PRIMARY]

    cred ca aici e greseala eu vreau ca dupa ce se proceseaza mesajul sa se stearga din coada

    Multumesc mult dinnou


    Secolul XXI ori va fi religios ori nu va fi deloc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems