Re: Notifcation of when data replicates - Transactional replication

Matthew,
the order of changes is indeed maintained in transactional replication,
provided the articles are in the same publication. If they were in separate
publications with independant agents, the order would depend on the order of
running the agents.
The trigger method could be used to flag the data arriving, and notification
Services or some sort of polling mechanism can be used to check for the
flag's existence. You could also check the distribution history tables to
determine when data was last sent over, but in your case it is the final
flag that seems to really indicate the next process can begin on the
subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Schema changes screw up transactional replication
    ... We have two servers with SQL Server 2005, ... There is a transactional replication between them but when we make ... We get this error message ... N'PublishedDatabase' and publication= N'PublicationName') ...
    (microsoft.public.sqlserver.replication)
  • Replicating Stored Procedure permissions issue
    ... I'm having a problem replicating stored procedure permssions accross ... two sql server 2005 servers, using transactional replication. ... publication for all my tables, and another for SPs, UDFs and views. ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Causing App Timouts
    ... Is this SQL Server 2000? ... If so you need to use the concurrent snapshot option. ... If it is SQL 2005 I would try to script out the publication creation statements and then run them from query analyzer. ... I would also look at using transactional replication to avoid the overhead of sending every row every time. ...
    (microsoft.public.sqlserver.replication)
  • RE: Remove Article from Merge replication
    ... unlike transactional replication this is not possible via normal means. ... best bet is to drop the publication and recreate without the 2 tables. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Cant Use "Transacional publication" Option (Its Grayed Out!)
    ... I suspect your SQL Server version is MSDE - transactional replication is not ... > Used the Wizard to Creat Publication for the first time. ... > How can I get to select Publication using the 'Transaction' type? ...
    (microsoft.public.sqlserver.replication)