Can a SQL Server Express talk with other SQL Server Express in the same network?

Hi

There is a service from SQL Server 2005 that "listens" to the network, if the network is down, all data gets saved within the local instance of the SQL server 2005. And when the network becomes available, the local instance of the sql server will automatically "feed" the local records to the central SQL server 2005.

What is that feature called?

It sounds like you're talking about Service Broker, but Service Broker doesn't support communication between two Express instances. Service Broker communication between SQL instances must include a paid edition somewhere in the message chain. I'm not aware of any other tools that support the type of communication you've describe.

Mike

|||

Mike,thanks for the information.

I will look into service broker

Thanks