Very Computer

Dear friends: -
                      I am an internee at a firm and i am working on a
project in which i am supposed to synchronize two databases separated via
LAN without using DTS facilities provided by SQL server. So i am having
problem in accessing the transaction log to find out the previous
transactions that were made by the DBMS  via Visual C++(preferable) or
Visual Basic so that i can generate an XML file and make the same changes in
the other database. Reply me by giving  me some reference to MSDN or a site
or some book(not really because i donot have much money to buy some new
one).
                                         Thanking in anticipation
                                             Khurram Javed

Rather than re-inventing the wheel, why not just use replication?

---------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.

Quote:> Dear friends: -
>                       I am an internee at a firm and i am working on a
> project in which i am supposed to synchronize two databases separated via
> LAN without using DTS facilities provided by SQL server. So i am having
> problem in accessing the transaction log to find out the previous
> transactions that were made by the DBMS  via Visual C++(preferable) or
> Visual Basic so that i can generate an XML file and make the same changes in
> the other database. Reply me by giving  me some reference to MSDN or a site
> or some book(not really because i donot have much money to buy some new
> one).
>                                          Thanking in anticipation
>                                              Khurram Javed