creating service broker between two instances

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 10 Jun 2008 16:58 GMT

Hello there

I have one server with 2 instances.

I would like to create service broker between these two instances

how can i do it?

Reply to this Message

Alan Brewer [MSFT] - 10 Jun 2008 19:26 GMT

There is a tutorial on how to set up a conversation between two instances.
The tutorial works in either SQL Server 2005 or SQL Server 2008.

SQL Server 2005: http://msdn.microsoft.com/en-us/library/bb839483.aspx
SQL Server 2008 RC0:
http://msdn.microsoft.com/en-us/library/bb839483(SQL.100).aspx

Signature

Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Roy Goldhammer - 11 Jun 2008 09:22 GMT

Thanks Alan.

The problem solved after i set diffrent port for each service.

Now i would like to set event (listiner) on one of my tables so each action
which is inserted, updated or deleted will be entered to the queue as xml so
can set the changes at secondery server.

how can i do it?

> There is a tutorial on how to set up a conversation between two instances.
> The tutorial works in either SQL Server 2005 or SQL Server 2008.
>
> SQL Server 2005: http://msdn.microsoft.com/en-us/library/bb839483.aspx
> SQL Server 2008 RC0:
> http://msdn.microsoft.com/en-us/library/bb839483(SQL.100).aspx

Reply to this Message