Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Service Broker Transact-SQL Enhancements

SQL Server 2005

Service Broker is a technology that helps developers build database-intensive, distributed applications that are secure, reliable, and scalable. This technology allows distributed application components to reliably send and receive messages and to queue those messages until they can be processed by the receiving component.

New statements Description

CREATE CONTRACT (Transact-SQL)

Creates a new contract in a database.

DROP CONTRACT (Transact-SQL)

Deletes an existing contract.

ALTER MESSAGE TYPE (Transact-SQL)

Changes the properties of a message type.

CREATE MESSAGE TYPE (Transact-SQL)

Creates a new message type in a database.

DROP MESSAGE TYPE (Transact-SQL)

Deletes an existing message type.

ALTER QUEUE (Transact-SQL)

Changes the properties of a queue.

CREATE QUEUE (Transact-SQL)

Creates a new queue in a database.

DROP QUEUE (Transact-SQL)

Deletes an existing queue.

ALTER REMOTE SERVICE BINDING (Transact-SQL)

Changes the properties of a remote service binding.

CREATE REMOTE SERVICE BINDING (Transact-SQL)

Creates a binding that associates a remote service with user credentials for accessing the service.

DROP REMOTE SERVICE BINDING (Transact-SQL)

Deletes an existing remote service binding.

ALTER ROUTE (Transact-SQL)

Changes the properties of a route.

CREATE ROUTE (Transact-SQL)

Creates a new route to a service.

DROP ROUTE (Transact-SQL)

Deletes an existing route.

ALTER SERVICE (Transact-SQL)

Changes the properties of a service.

CREATE SERVICE (Transact-SQL)

Creates a new service in a database.

DROP SERVICE (Transact-SQL)

Deletes an existing service.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.