MZ @ !L!This program cannot be run in DOS mode.
$ PE L
PC ! P g `. & g K ( f H .text G P `.rsrc ( ` @ @.reloc p @ B g H `W " P5 P uI> "봈St&KMoHj9%@Rf{:b*
@v>PHTKI2J{}-2d}j ~B)*uR}BhJ`@1nR2^s#2(
* (
* 0 T s
+7Jo
- 3 + 3 - + +,- o
&%JXTJo
2o
*0 3 -*s
X [ ]( o
1
o
+* (
* 0 h { -(
-*( } % ,"r p(
-r! p(
-+ + { o
2*{ o
*"} * (
*
;
0
+
dp.principal_id = mt.principal_id
n.xml_collection_id = mt.xml_collection_id
n.schema_id = ss.schema_id
MessageType
mt.message_type_id
case mt.validation when 'N ' then 0
when 'X' then case when mt.xml_collection_id is null then 3 else 1 end
when 'E' then 2 end
mt.name
dp.name
n.name
ss.name
15
mt.message_type_id = scmu.message_type_id
MessageTypeMapping
mt.name
scmu.service_contract_id
(case when scmu.is_sent_by_initiator=1 and is_sent_by_target=0 then 0
when scmu.is_sent_by_initiator=0 and is_sent_by_target=1 then 1
when scmu.is_sent_by_initiator=1 and is_sent_by_target=1 then 2 end )
v
dp.principal_id = sc.principal_id
16
ServiceContract
sc.name
sc.service_contract_id
dp.name
sc.service_contract_id = scu.service_contract_id
ServiceContractMapping
scu.service_id
sc.name
obj.type='SQ' and sq.object_id=obj.object_id
dp.principal_id = sq.execute_as_principal_id
ss.schema_id = sq.schema_id
sq.object_id = it.parent_object_id
ind.object_id = it.object_id and ind.index_id < 2
fg.data_space_id = ind.data_space_id
1
sq.name
sq.object_id
obj.create_date
obj.modify_date
dp.name
(case when ISNULL(sq.execute_as_principal_id, -1) < 0 then 2 else 3 end)
sq.max_readers
N''
N''
N''
sq.activation_procedure
ss.name
fg.name
ISNULL((SELECT p.rows from sys.internal_tables as it
join sys.indexes as i on i.object_id = it.object_id and i.index_id = 1
join sys.partitions as p on p.object_id = i.object_id and p.index_id = i.index_id
where sq.object_id = it.parent_id and it.parent_minor_id = 0 and it.internal_type = 201 ), 0)
sq.is_activation_enabled
sq.is_enqueue_enabled
sq.is_retention_enabled
dp.principal_id = s.principal_id
so.object_id = s.service_queue_id
sysob.object_id = s.service_queue_id
17
BrokerService
s.name
s.service_id
dp.name
so.name
schema_name(sysob.schema_id)
:
dp.principal_id = sb.principal_id
dp2.principal_id = sb.remote_principal_id
18
RemoteServiceBinding
sb.remote_service_binding_id
cast(sb.name as varbinary(256))
dp.name
sb.remote_service_name
sb.is_anonymous_on
dp2.name
dp.principal_id = sr.principal_id
19
ServiceRoute
sr.name
sr.route_id
dp.name
ISNULL(sr.remote_service_name, N'')
ISNULL(sr.broker_instance, N'')
sr.lifetime
sr.address
ISNULL(sr.mirror_address, N'')
BSJB v2.0.50727 l #~ #Strings | H #US #GUID #Blob W 3
,
F? M
Y?
p^
^
^
^
3^
N^
g^
^
?
^
.^
M^
j^
[
~
? 4 K u K z K
K K K
K 0 #< V+? V0? V9? VB? VN? VX? #< Vca Voa V~a #< Vj Vj Vj Vj #< Vs Vs Vs Vw y ! @! * ! ! 4 ! " P ] m x A I Q Y a i q y ) ;H M R X \1 1 h u |1 X1 C H M R W \ ( e , C 0 H 8 e < C @ H D n L e P C T H X z . . . # . + E. 3 _. ; z. C . K . S z. c z. k z. s z. { . . `n
6
?
( ) : H J 8 a s H P & * 80 Microsoft.SqlServer.ServiceBrokerEnum.dll ServiceBrokerSqlObject Microsoft.SqlServer.Management.Smo.Broker Util PostProcessSplitTriPartName DialogEndPointState DialogType MessageTypeValidation MessageSource AssemblyVersionInfo Microsoft.SqlServer.SqlEnum Microsoft.SqlServer.Management.Smo SqlObject mscorlib System Object PostProcess Enum System.Reflection Assembly get_ResourceAssembly .ctor ResourceAssembly UnEscapeString System.Collections.Specialized StringCollection SplitNames m_listNames DataProvider GetColumnData CleanRowData value__ Open OpenWait Disabled ClosingWait ErrorWait ClosedWait Regular2Way MonologPublish MonologReceive None XmlSchemaCollection Empty Xml Initiator Target InitiatorAndTarget VersionString AssemblyFileVersionAttribute AssemblyVersionAttribute AssemblyTrademarkAttribute AssemblyCopyrightAttribute AssemblyProductAttribute AssemblyCompanyAttribute AssemblyKeyNameAttribute System.Resources NeutralResourcesLanguageAttribute CLSCompliantAttribute System.Runtime.InteropServices ComVisibleAttribute AssemblyCultureAttribute AssemblyConfigurationAttribute AssemblyDescriptionAttribute AssemblyTitleAttribute System.Diagnostics DebuggableAttribute DebuggingModes System.Runtime.CompilerServices CompilationRelaxationsAttribute RuntimeCompatibilityAttribute Microsoft.SqlServer.ServiceBrokerEnum GetExecutingAssembly escapedValue startEscapeChar escapeChar index System.Text StringBuilder String get_Chars Append get_Length ToString name Insert data dp GetTriggeredString op_Equality get_Count get_Item inc_urn.xml inc_urn_schema.xml inc_ext_prop.xml MessageType.xml MessageTypeMapping.xml ServiceBroker.xml ServiceContract.xml ServiceContractMapping.xml ServiceQueues.xml BrokerService.xml RemoteServiceBinding.xml ServiceRoute.xml P r o c e d u r e S c h e m a #P r o c e d u r e D a t a b a s e gQn]i%DcĬK ]̀̑z\V4 ( 9 . 0 0 . 2 4 2 . 0 0 ] $ $ RSA1 ''6n_1:fl/y2}/R4H<=\]Ǽ(k,Q\$+Au2IRmRo {lO1
ˢ#V{-Pb왹J|};( i i 9.00.1399.00 x sMicrosoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation , '© Microsoft Corp. All rights reserved. Microsoft SQL Server Microsoft Corporation
en-US TWrapNonExceptionThrows
PC B g W RSDS8րuGb<] Microsoft.SqlServer.ServiceBrokerEnum.pdb g g g _CorDllMain mscoree.dll % `. 0 H X 4 V S _ V E R S I O N _ I N F O w w? D V a r F i l e I n f o $ T r a n s l a t i o n , S t r i n g F i l e I n f o 0 0 0 0 0 4 b 0 L C o m p a n y N a m e M i c r o s o f t C o r p o r a t i o n , F i l e D e s c r i p t i o n <
F i l e V e r s i o n 9 . 0 0 . 1 3 9 9 . 0 0 t * I n t e r n a l N a m e M i c r o s o f t . S q l S e r v e r . S e r v i c e B r o k e r E n u m . d l l t ' L e g a l C o p y r i g h t M i c r o s o f t C o r p . A l l r i g h t s r e s e r v e d . s L e g a l T r a d e m a r k s M i c r o s o f t i s a r e g i s t e r e d t r a d e m a r k o f M i c r o s o f t C o r p o r a t i o n . W i n d o w s ( T M ) i s a t r a d e m a r k o f M i c r o s o f t C o r p o r a t i o n | * O r i g i n a l F i l e n a m e M i c r o s o f t . S q l S e r v e r . S e r v i c e B r o k e r E n u m . d l l L P r o d u c t N a m e M i c r o s o f t S Q L S e r v e r @
P r o d u c t V e r s i o n 9 . 0 0 . 1 3 9 9 . 0 0 <
A s s e m b l y V e r s i o n 9 . 0 . 2 4 2 . 0 ` 7 0 *H
01 0 + 0h
+7Z0X03
+70% < < < O b s o l e t e > > >0!0 + QCKe \#e)I*00-GߍRFCmH
10
*H
01 0 UZA10U Western Cape10U Durbanville10
U
Thawte1 0U Thawte Certification1 0 UThawte Timestamping CA0
031204000000Z
131203235959Z0S1 0 UUS10U
VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA0"0
*H
0
ʲ
}uNgad ڻ30X~k6xw~o<
hlʽR-H=]_/k LR`@ ~
?Ǵ߇_zj1.G 1s
W-x43h/*Ë!fXWou<&]' x1"ijGC_ ^|}bM "Vͮv
M٠h; 004+(0&0$+0http://ocsp.verisign.com0U 0 0AU :0806420http://crl.verisign.com/ThawteTimestampingCA.crl0U % 0
+0U 0$U 0010U TSA2048-1-530
*H
JkXD 1y+ LͰXn)^ʓR
G'/ 8ɓN"b?7!Op18 UN$ҩ'NzaA*^ݻ+>W~ +;R8'?J00
+)2 ^v0
*H
0S1 0 UUS10U
VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA0
031204000000Z
081203235959Z0W1 0 UUS10U
VeriSign, Inc.1/0-U&VeriSign Time Stamping Services Signer0"0
*H
0
P(HhzDfu]~ĸc&=C|8%Usu'iN \
*UV!a 3kݣ7e S \|f5_EvNS \0"7LB
U?R,z5]j=k㿖`@DQn*(P{J
0 kX@(
~|vqiOG05!b<+َ*{\{❥o<00 <<>c@0
*H
0p1+0)U "Copyright (c) 1997 Microsoft Corp.1 0 U Microsoft Corporation1!0 UMicrosoft Root Authority0
970110070000Z
201231070000Z0p1+0)U "Copyright (c) 1997 Microsoft Corp.1 0 U Microsoft Corporation1!0 UMicrosoft Root Authority0"0
*H
0
p;N(x^0ꢩ%_L >|Q`2kBdyvT뜆 fkzb# <Ŀ-fh&:, X&F
>8,(9IBlUa|`-wL陴d;P 1$+=c`Xe 7RӿUE:TNzmtN̖ (! W`i7Kc@0
*H
5$w\`2 >:!W,Gb;;Z6Ti$m?̪|1=pjOiCZ Ob{+7%-e%cT !RnC2gl
QRǽ0 1 )M [WeIRT(~ū7,zwv j?6A5jj5 EZ38nM
b
T?F Up:uҠ00j O "}ly~0
*H
0p1+0)U "Copyright (c) 1997 Microsoft Corp.1 0 U Microsoft Corporation1!0 UMicrosoft Root Authority0
020523080000Z
110925080000Z01 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1+0)U "Copyright (c) 2000 Microsoft Corp.1#0!UMicrosoft Code Signing PCA0 0
*H
0 >Pz$%v!*VNʜ5y- ĨcɷֱRƽŨkSPdԂh @xD8NcQ=7c#;q@4GkF's "B QRӣ?qm!D_Bəd 4D{ /ߛ!X1AU8~XYy%*/?8x>Bh~"hJxDRGOg{ }q<+f-+4He< &Ro*0&0U % 0
+0U 0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.1 0 U Microsoft Corporation1!0 UMicrosoft Root Authority <<>c@0 +7 0 U %+K]rT*S0 +7
S u b C A0 U F0U 00
*H
dJti'ZS' сsκꓗ:.tt;@Q_<2OY( rq/5B/b11BO8pA8`
< +VKJ"oD+pN,:q2X5Rۑ@o)Bp}loۜ^, _³{;St*g 'u@ Fr6mkfS 5 jrE ]f ,a Yf ;|00ɠ
aX Z0
*H
01 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1+0)U "Copyright (c) 2000 Microsoft Corp.1#0!UMicrosoft Code Signing PCA0
050105232019Z
060405233019Z0t1 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1 0 UMicrosoft Corporation0"0
*H
0
8'^̪:;b1FFӳLg(C;uyj3a zy ]hpw /u/JA||ˇCt@WXՒ$qIU|e 8 #>)lƞp[}7gw ΅N45 S2W(l@ I67 I*k̎ֆFzJESx/.5kL$iin>LAb]~\L'1kVL q=*qM @0<0U 0 U 4wh424c10U % 0
+0U #0%+K]rT*Str0p1+0)U "Copyright (c) 1997 Microsoft Corp.1 0 U Microsoft Corporation1!0 UMicrosoft Root Authorityj O "}ly~0JU C0A0?=;9http://crl.microsoft.com/pki/crl/products/CodeSignPCA.crl0
*H
& t< J'GrQKB Q#;e-LP8W^:sO3-%;YЮ R
dwwu6 l3`/m)۵k"@+2Pƶ6w)T>~qYʄ/D"!H
cro,+:YJ!埩bPu v_ؠ~W҉}C10001 0 UUS10U
Washington10URedmond1 0 U
Microsoft Corporation1+0)U "Copyright (c) 2000 Microsoft Corp.1#0!UMicrosoft Code Signing PCA
aX Z0 + 0 *H
1
+70
+7 10
+70# *H
1WK 3mG5ܥSS0X
+7 1J0H*( M i c r o s o f t S Q L S e r v e rhttp://www.microsoft.com0
*H
n,!xdBS*.۳ K1Xc$@j.(3/l([F9{( bKKH"C4fM變(_WPےs1n?:砜'1=9
p +-v6tKGv2 %A,bZq:o5ܤ_T?&K4,
U#ǧYq,k