Sorry for the misunderstanding. What I wanted was to configure MS DTC
to do the process without modifying any SQL query Code. I was told
that was a possibility. If that is incorrect, is there another way to
configure SQL Server 7 without modifying/writing any SQL query code to
automatically update both databases immediately after one DB was
updated? Thanks again.
> Come on, add a second sql server as an linked server and state:
> begin distributed transaction
> insert into dbo.yourtable ....
> insert into otherservername.dbname.dbo.yourtable...
> commit....
> Regards
> Kresimir Radosevic
> > I read the books online and the books I have but I could not find out
> > how to implement the process.
> > What I am looking for are examples on how to implement the process.
> > If you know of any please let me know. Thanks.
> > > Check out the BEGIN DISTRIBUTED TRANSACTION in books online.
> > > Hope that helps
> > > Kresimir Radosevic
> > > > Hello to all the gurus out there
> > > > I am not a DBA, but a ASP web page programmer who uses queries to
> > > > select, insert, delete, and update information in SQL Server tables.
> > > > Now I have been asked to find out how to get SQL Server to do
> > > > immediate updates in two similar databases on two similar servers (WIN
> > > > NT 4 & SQL SERVER 7)
> > > > If a user updates one of the databases through the web page, the other
> > > > database on the other server should be updated right away and vice
> > > > versa. I was told that no code should be written to do this because
> > > > MS DTC could do this process without any code.
> > > > The problem is that I have found very little about MS DTC and I have
> > > > no idea where to start. Can some guru help me please??????? Thanks
> > > > in advance.
by