Sir,

Your explanation means impossible to implement

"Any machine is offline, this 3 database is not updated. Once this 3 machine is online, this 3 database is updated respectively"

Looking for help

Sir,

Based on your instruction, I'm glad because my implementation of SQL Service Broker ("SSB") was worked. Really cool. Currently, I knew

1. How to using SSB to send message between 2...

Sir,

Now, I can communicate between 2 different database server on the different server.

My code as...

Sir,

Based on Adam Mechanics article, http://www.simple-talk.com/sql/learn-sql-server/service-broker-advanced-basics-workbench/

The sample saying that using port 9998.

It's ok If I'm using port 8221? This port is working properly.

FYI, my port 9998 is not...

🙂

tq sir. i'll try. will let you know if me facing any problem.

Sir,

I've study the article. I've a question.

Let's say, my Database

1. localsb_db1 on 192.168.1.1

2. localsb_db2...

Steve Jones - SSC Editor (11/28/2010)

---

It's not clear how you are using service broker here. If you have an insert in db X on Server A, does this insert (direct...

ok sir. i'll try first. will get back to you. if i've any problem to built the system integration scripts.

Sir,

Can you give me the sample of logic based on my case? I can't imagine that.

Sir,

My question on my current solutions.

***************************************************

I've as follow

1. ERP DB

2. Warehouse Management DB

3. Transport Management DB

*All database using SQL Server 2005 Standard Edition (32 bit)

All of this DB Server...

Sir,

How about data integrity? Atomicity, 2-phase-commit,...

tq sir

If I want to using Trigger, it's wrong?

Need explanation

tq sir