Current .Net Version: 2.0.50727
(select below)
.Net Framework
ADO.NET
ASP.NET/Web Forms
C#
Certifications
SQL Server
Visual C#
Windows Forms
XML Web Services
Mike's C#, VS.NET and SQL Blog
T-SQL Scripts
END CONVERSATION
-- Tested with SQL Server 2005 9.00.852 -- Ends a dialog conversation. -- This is a Service Broker feature. DECLARE @DialogHandle UNIQUEIDENTIFIER; BEGIN DIALOG @DialogHandle FROM SERVICE DotNetFunService TO SERVICE 'DotNetFunService' ON CONTRACT DotNetFunContractSentByAny; SEND ON CONVERSATION @DialogHandle MESSAGE TYPE [DotNetFunMessageTypeValidateNone] ('HELLO!'); /* NOTE: It's not necessary to explicitly end a conversation. The primary purpose of ending a conversation is to prevent any further messages from being added to the same conversation group. Another message will be added to the queue if you do explicitly end the conversation and it will have an activation of 'E' for 'End' and an mesage type of 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog'. After an END CONVERSATION is performed, any other messages belonging to the Message Group will not be allowed to send messages on that group accordingly. */ END CONVERSATION @DialogHandle;
Open/Save
|
E-mail
|
Back
COPYRIGHT/DISCLAIMER
|
CONTACT US
Current .Net Version: 2.0.50727
Current .Net Version: 2.0.50727
