TechTalkz.com Logo Ask the Expert

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft SQL Server

Notices

How to have replication and updates against 2 db’s living in harmo

Microsoft SQL Server


Reply
 
Thread Tools Display Modes
Old 08-12-2007, 06:16 AM   #11
rdmjrb
Guest
 
Posts: n/a
RE: How to have replication and updates against 2 db’s living in harmo

>>The src db is receiving updates from outside app constantly

This was the key point, it seems. By wrapping the entire job in a "outer"
transaction, this allowed the work-flow proccess to complete prior to any
replicated changes.

Harmony was achieved.
  Reply With Quote
Old 08-12-2007, 07:01 AM   #12
rdmjrb
Guest
 
Posts: n/a
RE: How to have replication and updates against 2 db’s living in harmo

>>The src db is receiving updates from outside app constantly

This was the key point, it seems. By wrapping the entire job in a "outer"
transaction, this allowed the work-flow proccess to complete prior to any
replicated changes.

Harmony was achieved.
  Reply With Quote
Reply

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT +5.5. The time now is 05:46 PM.


vBulletin, Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2010, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional