Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    128

    Unanswered: Service Broker example.

    Im having a hard time understanding everything required to create a simple Service Broker example. Can someone please assist? Source code would be ideal, but if not "do this, do that" would even be helpful.

    Thanks.

  2. #2
    Join Date
    Jul 2005
    Location
    New Zealand
    Posts
    61
    The very first thing you need to do is enable Service Broker on the database in question:
    Code:
    use mydb
    ALTER DATABASE mydb SET ENABLE_BROKER
    If you want to use Service Broker to handle event notifications you also need to create a Queue, a Service on that Queue and a Route on the Service.

    Have a look in the SQL2K5 online Help - there are lots of examples there.

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •