You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts two database named CK_Staff and CK_Projects.
You need to create a Service Broker to enable the CK_Staff and CK_Projects databases to communicate. You create three message types using the following Transact-SQL statements:
CREATE MESSAGE TYPE [// Domain.com/Staff/Name] VALIDATION = WELL_FORMED_XML ;
CREATE MESSAGE TYPE [// Domain.com/Projects/Budget] VALIDATION = WELL_FORMED_XML ;
CREATE MESSAGE TYPE [// Domain.com/Projects/Completion] VALIDATION = EMPTY ;
You now want to create a contract named // Domain.com/Project/Progress between two services that include the two message types. You want to ensure that both the sender and the target is able to use // Domain.com/Staff/Name message type; but that only the sender is able to use the // Domain.com/Projects/Budget message type, and only the target is able to use the // Domain.com/Projects/Completion message type.
Which CREATE CONTRACT statement should you use?