validation_desc is wrong for validation = N in sys.service_message_types by Tom Groszko

Active

Type:	Bug
ID:	778369
Opened:	2/2/2013 10:21:44 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

SELECT * FROM sys.service_message_types
shows a validation_desc of BINARY when the validation column = N. It should be NONE according to BOL. One or the other is wrong.

Details (expand)

English

SQL Server 2012 - Developer Edition

SQL Engine

Not Applicable

US English

SELECT * FROM sys.service_message_types

name    message_type_id    principal_id    validation    validation_desc    xml_collection_id
http://schemas.microsoft.com/SQL/ServiceBroker/Error    1    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog    2    1    E     EMPTY    NULL
http://schemas.microsoft.com/SQL/Notifications/QueryNotification    3    1    X     XML    NULL
http://schemas.microsoft.com/SQL/Notifications/EventNotification    4    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer    5    1    E     EMPTY    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRoute    6    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRoute    7    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRemoteServiceBinding    8    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRemoteServiceBinding    9    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho/Echo    10    1    N     BINARY    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query    11    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status    12    1    X     XML    NULL
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description    13    1    N     BINARY    NULL
DEFAULT    14    1    N     BINARY    NULL
http://ssb.csharp.at/SSB_Book/c03/RequestMessage    65536    1    N     BINARY    NULL
http://ssb.csharp.at/SSB_Book/c03/ResponseMessage    65537    1    N     BINARY    NULL

NONE when validation = N in the validation_desc column

X64

0 attachments

Posted by Microsoft on 2/13/2013 at 12:27 PM

Thanks for the feedback we are review this issue

Microsoft