Service Broker Transact-SQL Enhancements

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 DDL Statements

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.

See Also

Reference

Data Definition Language (DDL) Statements (Transact-SQL)

Other Resources

What's New and Enhanced in Transact-SQL (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance