/Kilimanjaro_SR1/ConversationPriority/README_ConversationPriority.htm
HTML | 766 lines | 208 code | 47 blank | 511 comment | 0 complexity | 5884495242efa3e603694dde3891ce5c MD5 | raw file
1<html xmlns:v="urn:schemas-microsoft-com:vml" 2xmlns:o="urn:schemas-microsoft-com:office:office" 3xmlns:w="urn:schemas-microsoft-com:office:word" 4xmlns="http://www.w3.org/TR/REC-html40" 5xmlns:ns0="http://www.microsoft.com/tooltip" 6xmlns:ns1="http://www.w3.org/1999/xlink" 7xmlns:ns2="http://ddue.schemas.microsoft.com/authoring/2003/5" 8xmlns:ns3="http://msdn.microsoft.com/mshelp"> 9 10<head> 11<meta http-equiv=Content-Type content="text/html; charset=utf-8"> 12<meta name=ProgId content=Word.Document> 13<meta name=Generator content="Microsoft Word 11"> 14<meta name=Originator content="Microsoft Word 11"> 15<link rel=File-List href="README_ConversationPriority_files/filelist.xml"> 16<title>Readme_ConversationPriority</title> 17<!--[if gte mso 9]><xml> 18 <o:DocumentProperties> 19 <o:Author>Michael Thomas</o:Author> 20 <o:LastAuthor>Michael Thomas</o:LastAuthor> 21 <o:Revision>4</o:Revision> 22 <o:TotalTime>42</o:TotalTime> 23 <o:Created>2007-08-16T17:21:00Z</o:Created> 24 <o:LastSaved>2007-08-17T00:08:00Z</o:LastSaved> 25 <o:Pages>1</o:Pages> 26 <o:Words>525</o:Words> 27 <o:Characters>2995</o:Characters> 28 <o:Company>Microsoft Corporation</o:Company> 29 <o:Lines>24</o:Lines> 30 <o:Paragraphs>7</o:Paragraphs> 31 <o:CharactersWithSpaces>3513</o:CharactersWithSpaces> 32 <o:Version>11.9999</o:Version> 33 </o:DocumentProperties> 34</xml><![endif]--><!--[if gte mso 9]><xml> 35 <w:WordDocument> 36 <w:SpellingState>Clean</w:SpellingState> 37 <w:GrammarState>Clean</w:GrammarState> 38 <w:ValidateAgainstSchemas/> 39 <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> 40 <w:IgnoreMixedContent>false</w:IgnoreMixedContent> 41 <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> 42 <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> 43 </w:WordDocument> 44</xml><![endif]--><!--[if gte mso 9]><xml> 45 <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> 46 </w:LatentStyles> 47</xml><![endif]--> 48<style> 49<!-- 50div.#mainSection 51{ 52 font-size: 70%; 53 width: 100%; 54 padding-left: 10; 55 margin-right: 10; 56} 57div.#mainBody 58{ 59 font-size: 90%; 60 margin-top: 10; 61 padding-bottom: 20; 62} 63div.#header 64{ 65 background-color: #D2D2D2; 66 padding-top: 0; 67 padding-bottom: 0; 68 padding-left: 10; 69 padding-right: 0; 70 width: 100%; 71} 72div.#header table 73{ 74 border-bottom-color: #C8CDDE; 75 border-bottom-style: solid; 76 border-bottom-width: 1; 77 width: 100%; 78} 79span.#runningHeaderText 80{ 81 color: #003399; 82 font-size: 90%; 83} 84span.#nsrTitle 85{ 86/* color: #003399;*/ 87 font-size: 120%; 88 font-weight: 600; 89} 90div.#header table td 91{ 92 color: #000000; 93 font-size: 70%; 94 margin-top: 0; 95 margin-bottom: 0; 96 padding-right: 20; 97} 98div.#header table tr.#headerTableRow3 td 99{ 100 padding-bottom: 2; 101 padding-top: 5; 102} 103div.#header table.#bottomTable 104{ 105 border-top-color: #FFFFFF; 106 border-top-style: solid; 107 border-top-width: 1; 108 text-align: left; 109} 110div.#footer 111{ 112 font-size: 90%; 113 margin-top: 0; 114 margin-bottom: 0; 115 margin-left: -5; 116 margin-right: 0; 117 padding-top: 2; 118 padding-bottom: 2; 119 padding-left: 0; 120 padding-right: 0; 121 width: 100%; 122} 123hr.#footerHR 124{ 125 border-bottom-color: #EEEEFF; 126 border-bottom-style: solid; 127 border-bottom-width: 1; 128 border-top-color: C8CDDE; 129 border-top-style: solid; 130 border-top-width: 1; 131 height: 3; 132 color: #D2D2D2; 133} 134img.#membersOptionsFilterImage 135{ 136 border: 0; 137 margin-left: 10; 138 vertical-align: middle; 139 padding-bottom: 10; 140} 141img.#toggleAllImage 142{ 143 margin-left: 4; 144 vertical-align: middle; 145 padding-bottom: 10; 146} 147div.#mainSection table 148{ 149 border: 0; 150 font-size: 100%; 151 width: 100%; 152 margin-top: 5px; 153 margin-bottom: 15px; 154} 155div.#mainSection table tr 156{ 157 vertical-align: top; 158} 159div.#mainSection table th 160{ 161 text-align: left; 162 background: #D8D8D8; 163 border-bottom-color: #D8D8D8; 164 border-bottom-style: solid; 165 border-bottom-width: 1; 166 color: #000000; 167 padding-left: 5; 168 padding-right: 5; 169} 170div.#mainSection table td 171{ 172 background: #F2F2F2; 173 border-top-color: #D8D8D8; 174 border-top-style: solid; 175 border-top-width: 1; 176 padding-left: 5; 177 padding-right: 5; 178} 179div.#mainSection table td.imageCell 180{ 181 white-space: nowrap; 182} 183span.COPYCODE 184 {cursor:hand; 185 float:right;} 186.DOWNLOADCODE 187 {cursor:hand;} 188.VIEWCODE 189 {cursor:hand;} 190.TIP 191 {cursor:hand;} 192pre.VIEWCODE 193 {overflow:auto;} 194li:hover table, li.over table 195{ 196 background-color: #C0C0C0; 197} 198li:hover ul, li.over ul 199{ 200 background-color: #d2d2d2; 201 border: 1px solid #000; 202 display: block; 203} 204 205 /* Font Definitions */ 206 @font-face 207 {font-family:Verdana; 208 panose-1:2 11 6 4 3 5 4 4 2 4; 209 mso-font-charset:0; 210 mso-generic-font-family:swiss; 211 mso-font-pitch:variable; 212 mso-font-signature:536871559 0 0 0 415 0;} 213@font-face 214 {font-family:"Segoe UI"; 215 panose-1:2 11 5 2 4 2 4 2 2 3; 216 mso-font-charset:0; 217 mso-generic-font-family:swiss; 218 mso-font-pitch:variable; 219 mso-font-signature:-536870145 1073750107 1 0 415 0;} 220 /* Style Definitions */ 221 p.MsoNormal, li.MsoNormal, div.MsoNormal 222 {mso-style-parent:""; 223 margin:0in; 224 margin-bottom:.0001pt; 225 mso-pagination:widow-orphan; 226 font-size:12.0pt; 227 font-family:"Times New Roman"; 228 mso-fareast-font-family:"Times New Roman";} 229h1 230 {mso-margin-top-alt:auto; 231 margin-right:0in; 232 mso-margin-bottom-alt:auto; 233 margin-left:0in; 234 mso-pagination:widow-orphan; 235 mso-outline-level:1; 236 font-size:24.0pt; 237 font-family:"Times New Roman"; 238 font-weight:bold;} 239h2 240 {mso-margin-top-alt:auto; 241 margin-right:0in; 242 mso-margin-bottom-alt:auto; 243 margin-left:0in; 244 mso-pagination:widow-orphan; 245 mso-outline-level:2; 246 font-size:18.0pt; 247 font-family:"Times New Roman"; 248 font-weight:bold;} 249h3 250 {mso-margin-top-alt:auto; 251 margin-right:0in; 252 mso-margin-bottom-alt:auto; 253 margin-left:0in; 254 mso-pagination:widow-orphan; 255 mso-outline-level:3; 256 font-size:13.5pt; 257 font-family:"Times New Roman"; 258 font-weight:bold;} 259h4 260 {mso-margin-top-alt:auto; 261 margin-right:0in; 262 mso-margin-bottom-alt:auto; 263 margin-left:0in; 264 mso-pagination:widow-orphan; 265 mso-outline-level:4; 266 font-size:12.0pt; 267 font-family:"Times New Roman"; 268 font-weight:bold;} 269h5 270 {mso-margin-top-alt:auto; 271 margin-right:0in; 272 mso-margin-bottom-alt:auto; 273 margin-left:0in; 274 mso-pagination:widow-orphan; 275 mso-outline-level:5; 276 font-size:10.0pt; 277 font-family:"Times New Roman"; 278 font-weight:bold;} 279a:link, span.MsoHyperlink 280 {color:blue; 281 text-decoration:underline; 282 text-underline:single;} 283a:visited, span.MsoHyperlinkFollowed 284 {color:purple; 285 text-decoration:underline; 286 text-underline:single;} 287p 288 {mso-margin-top-alt:auto; 289 margin-right:0in; 290 margin-bottom:11.25pt; 291 margin-left:0in; 292 mso-pagination:widow-orphan; 293 font-size:12.0pt; 294 font-family:"Times New Roman"; 295 mso-fareast-font-family:"Times New Roman";} 296code 297 {mso-ansi-font-size:12.5pt; 298 mso-bidi-font-size:12.5pt; 299 font-family:"Courier New"; 300 mso-ascii-font-family:"Courier New"; 301 mso-fareast-font-family:"Times New Roman"; 302 mso-hansi-font-family:"Courier New"; 303 mso-bidi-font-family:"Courier New"; 304 color:black;} 305pre 306 {margin:0in; 307 margin-bottom:.0001pt; 308 mso-pagination:widow-orphan; 309 tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; 310 font-size:10.0pt; 311 font-family:"Courier New"; 312 mso-fareast-font-family:"Times New Roman";} 313p.heading, li.heading, div.heading 314 {mso-style-name:heading; 315 margin-top:13.5pt; 316 margin-right:0in; 317 margin-bottom:6.0pt; 318 margin-left:0in; 319 mso-pagination:widow-orphan; 320 font-size:12.0pt; 321 font-family:"Times New Roman"; 322 mso-fareast-font-family:"Times New Roman"; 323 color:black; 324 font-weight:bold;} 325p.subheading, li.subheading, div.subheading 326 {mso-style-name:subheading; 327 mso-margin-top-alt:auto; 328 margin-right:0in; 329 margin-bottom:3.0pt; 330 margin-left:0in; 331 mso-pagination:widow-orphan; 332 font-size:18.0pt; 333 font-family:"Times New Roman"; 334 mso-fareast-font-family:"Times New Roman"; 335 color:black; 336 font-weight:bold;} 337p.downloadcode, li.downloadcode, div.downloadcode 338 {mso-style-name:downloadcode; 339 mso-margin-top-alt:auto; 340 margin-right:0in; 341 margin-bottom:11.25pt; 342 margin-left:0in; 343 mso-pagination:widow-orphan; 344 font-size:11.0pt; 345 font-family:"Times New Roman"; 346 mso-fareast-font-family:"Times New Roman"; 347 color:blue;} 348p.viewcode, li.viewcode, div.viewcode 349 {mso-style-name:viewcode; 350 mso-margin-top-alt:auto; 351 margin-right:0in; 352 margin-bottom:11.25pt; 353 margin-left:0in; 354 mso-pagination:widow-orphan; 355 font-size:11.0pt; 356 font-family:"Times New Roman"; 357 mso-fareast-font-family:"Times New Roman"; 358 color:blue;} 359p.tip, li.tip, div.tip 360 {mso-style-name:tip; 361 mso-margin-top-alt:auto; 362 margin-right:0in; 363 margin-bottom:11.25pt; 364 margin-left:0in; 365 mso-pagination:widow-orphan; 366 font-size:12.0pt; 367 font-family:"Times New Roman"; 368 mso-fareast-font-family:"Times New Roman"; 369 color:blue; 370 font-style:italic; 371 text-decoration:underline; 372 text-underline:single;} 373p.math, li.math, div.math 374 {mso-style-name:math; 375 mso-margin-top-alt:auto; 376 margin-right:0in; 377 margin-bottom:11.25pt; 378 margin-left:0in; 379 mso-pagination:widow-orphan; 380 font-size:15.0pt; 381 font-family:"Times New Roman"; 382 mso-fareast-font-family:"Times New Roman";} 383p.sourcecodelist, li.sourcecodelist, div.sourcecodelist 384 {mso-style-name:sourcecodelist; 385 mso-margin-top-alt:auto; 386 margin-right:0in; 387 margin-bottom:11.25pt; 388 margin-left:0in; 389 mso-pagination:widow-orphan; 390 font-size:11.0pt; 391 font-family:Verdana; 392 mso-fareast-font-family:"Times New Roman"; 393 mso-bidi-font-family:"Times New Roman";} 394span.copycode 395 {mso-style-name:copycode; 396 mso-ansi-font-size:11.0pt; 397 mso-bidi-font-size:11.0pt; 398 color:blue; 399 mso-hide:none; 400 font-weight:normal;} 401span.SpellE 402 {mso-style-name:""; 403 mso-spl-e:yes;} 404span.GramE 405 {mso-style-name:""; 406 mso-gram-e:yes;} 407@page Section1 408 {size:8.5in 11.0in; 409 margin:1.0in 1.25in 1.0in 1.25in; 410 mso-header-margin:.5in; 411 mso-footer-margin:.5in; 412 mso-paper-source:0;} 413div.Section1 414 {page:Section1;} 415 /* List Definitions */ 416 @list l0 417 {mso-list-id:823735934; 418 mso-list-template-ids:1963622266;} 419@list l0:level1 420 {mso-level-tab-stop:.5in; 421 mso-level-number-position:left; 422 text-indent:-.25in;} 423@list l0:level2 424 {mso-level-tab-stop:1.0in; 425 mso-level-number-position:left; 426 text-indent:-.25in;} 427@list l0:level3 428 {mso-level-tab-stop:1.5in; 429 mso-level-number-position:left; 430 text-indent:-.25in;} 431@list l0:level4 432 {mso-level-tab-stop:2.0in; 433 mso-level-number-position:left; 434 text-indent:-.25in;} 435@list l0:level5 436 {mso-level-tab-stop:2.5in; 437 mso-level-number-position:left; 438 text-indent:-.25in;} 439@list l0:level6 440 {mso-level-tab-stop:3.0in; 441 mso-level-number-position:left; 442 text-indent:-.25in;} 443@list l0:level7 444 {mso-level-tab-stop:3.5in; 445 mso-level-number-position:left; 446 text-indent:-.25in;} 447@list l0:level8 448 {mso-level-tab-stop:4.0in; 449 mso-level-number-position:left; 450 text-indent:-.25in;} 451@list l0:level9 452 {mso-level-tab-stop:4.5in; 453 mso-level-number-position:left; 454 text-indent:-.25in;} 455@list l1 456 {mso-list-id:2024815862; 457 mso-list-template-ids:-785100540;} 458@list l1:level1 459 {mso-level-number-format:bullet; 460 mso-level-text:; 461 mso-level-tab-stop:.5in; 462 mso-level-number-position:left; 463 text-indent:-.25in; 464 mso-ansi-font-size:10.0pt; 465 font-family:Symbol;} 466@list l1:level2 467 {mso-level-tab-stop:1.0in; 468 mso-level-number-position:left; 469 text-indent:-.25in;} 470@list l1:level3 471 {mso-level-tab-stop:1.5in; 472 mso-level-number-position:left; 473 text-indent:-.25in;} 474@list l1:level4 475 {mso-level-tab-stop:2.0in; 476 mso-level-number-position:left; 477 text-indent:-.25in;} 478@list l1:level5 479 {mso-level-tab-stop:2.5in; 480 mso-level-number-position:left; 481 text-indent:-.25in;} 482@list l1:level6 483 {mso-level-tab-stop:3.0in; 484 mso-level-number-position:left; 485 text-indent:-.25in;} 486@list l1:level7 487 {mso-level-tab-stop:3.5in; 488 mso-level-number-position:left; 489 text-indent:-.25in;} 490@list l1:level8 491 {mso-level-tab-stop:4.0in; 492 mso-level-number-position:left; 493 text-indent:-.25in;} 494@list l1:level9 495 {mso-level-tab-stop:4.5in; 496 mso-level-number-position:left; 497 text-indent:-.25in;} 498ol 499 {margin-bottom:0in;} 500ul 501 {margin-bottom:0in;} 502--> 503</style> 504<!--[if gte mso 10]> 505<style> 506 /* Style Definitions */ 507 table.MsoNormalTable 508 {mso-style-name:"Table Normal"; 509 mso-tstyle-rowband-size:0; 510 mso-tstyle-colband-size:0; 511 mso-style-noshow:yes; 512 mso-style-parent:""; 513 mso-padding-alt:0in 5.4pt 0in 5.4pt; 514 mso-para-margin:0in; 515 mso-para-margin-bottom:.0001pt; 516 mso-pagination:widow-orphan; 517 font-size:10.0pt; 518 font-family:"Times New Roman"; 519 mso-ansi-language:#0400; 520 mso-fareast-language:#0400; 521 mso-bidi-language:#0400;} 522</style> 523<![endif]--> 524<meta name=save content=history> 525<!--[if gte mso 9]><xml> 526 <o:shapedefaults v:ext="edit" spidmax="4098"/> 527</xml><![endif]--><!--[if gte mso 9]><xml> 528 <o:shapelayout v:ext="edit"> 529 <o:idmap v:ext="edit" data="1"/> 530 </o:shapelayout></xml><![endif]--> 531</head> 532 533<body bgcolor=white lang=EN-US link=blue vlink=purple style='tab-interval:.5in'> 534 535<div class=Section1> 536 537<div id=header> 538 539<table class=MsoNormalTable border=0 cellpadding=0 width="100%" 540 style='width:100.0%;mso-cellspacing:1.5pt;mso-padding-alt:0in 5.4pt 0in 5.4pt'> 541 <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> 542 <td style='padding:.75pt .75pt .75pt .75pt'> 543 <p class=MsoNormal><span class=SpellE><span style='font-size:13.5pt; 544 font-family:Verdana;color:black'>Readme_ConversationPriority</span></span><span 545 style='font-size:13.5pt;font-family:Verdana;color:black'> <o:p></o:p></span></p> 546 </td> 547 <td style='padding:.75pt .75pt .75pt .75pt'><span id=headfb></span> 548 <p class=MsoNormal align=right style='text-align:right'><span 549 style='font-size:13.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></p> 550 </td> 551 </tr> 552 <tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes' id=headerTableRow3> 553 <td style='padding:.75pt .75pt .75pt .75pt'> 554 <p class=MsoNormal><span style='font-size:13.5pt;font-family:Verdana; 555 color:black'><o:p> </o:p></span></p> 556 </td> 557 <td style='padding:.75pt .75pt .75pt .75pt'> 558 <p class=MsoNormal align=right style='text-align:right'><span 559 style='font-size:13.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></p> 560 </td> 561 </tr> 562</table> 563 564</div> 565 566<div id=mainSection> 567 568<div id=mainBody> 569 570<p class=MsoNormal><span style='font-size:13.5pt;font-family:Verdana; 571color:darkgray'>[This topic is pre-release documentation and is subject to 572change in future releases. Blank topics are included as placeholders.] </span><span 573style='font-size:13.5pt;font-family:Verdana;color:black'><o:p></o:p></span></p> 574 575<p><span id=changeHistory></span><span style='font-size:13.5pt;font-family: 576Verdana;color:black'>The Conversation Priority sample provides a simple Service 577Broker application that shows you how to user broker priorities for sending and 578receiving a messages using Service Broker.<o:p></o:p></span></p> 579 580<p><span style='font-size:13.5pt;font-family:Verdana;color:black'>Samples are 581provided for educational purposes only. They are not intended to be used in a 582production environment and have not been tested in a production environment. 583Microsoft does not provide technical support for these samples. Sample 584applications and assemblies should not be connected to or used with your 585production SQL Server database or your report server without the permission of 586the system administrator. <o:p></o:p></span></p> 587 588<p><span style='font-size:13.5pt;font-family:Verdana;color:black'>Before 589running this sample:<o:p></o:p></span></p> 590 591<p style='margin-left:16.5pt;text-indent:-.25in;mso-list:l1 level1 lfo2; 592tab-stops:list .5in'><![if !supportLists]><span style='font-size:10.0pt; 593mso-bidi-font-size:12.0pt;font-family:Symbol;mso-fareast-font-family:Symbol; 594mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>·<span 595style='font:7.0pt "Times New Roman"'> 596</span></span></span><![endif]>Make sure that SQL Server is installed, including 597the SQL Server Database Engine component.<o:p></o:p></p> 598 599<p style='margin-left:16.5pt;text-indent:-.25in;mso-list:l1 level1 lfo2; 600tab-stops:list .5in'><![if !supportLists]><span style='font-size:10.0pt; 601mso-bidi-font-size:12.0pt;font-family:Symbol;mso-fareast-font-family:Symbol; 602mso-bidi-font-family:Symbol'></br><span style='mso-list:Ignore'>·<span 603style='font:7.0pt "Times New Roman"'> 604</span></span></span><![endif]>Install the SQL Service Broker product samples 605from the Releases tab at <b><span style='font-family:"Segoe UI"'><a 606href="http://www.codeplex.com/MSFTSBProdSamples"><span style='color:#3E62A6'>Microsoft 607SQL Server Product Samples: Service Broker</span></a></span></b>.<o:p></o:p></p> 608 609<h1 style='margin-top:13.5pt;margin-right:0in;margin-bottom:6.0pt;margin-left: 6100in'><span style='font-size:20.5pt;font-family:Verdana;color:black'></br>Running 611the Sample<o:p></o:p></span></h1> 612 613<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 614 615<div id=sectionSection0> 616 617<h4><span style='font-size:15.0pt;font-family:Verdana;color:navy'>To run the 618sample<o:p></o:p></span></h4> 619 620<content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 621 622<div xmlns="" id=procedureSectionEBBDBHA> 623 624<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 625tab-stops:list .5in'><![if !supportLists]><span style='font-size:13.5pt; 626font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 627color:black'><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> 628</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 629color:black'>Open the project file <span class=SpellE>ConversationPriority.ssmssqlproj</span> 630in SQL Server Management Studio.<o:p></o:p></span></p> 631 632<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 633tab-stops:list .5in' xmlns=""><![if !supportLists]><span style='font-size:13.5pt; 634font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 635color:black'><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> 636</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 637color:black'>Run <span class=SpellE>ClientSetup.sql</span>. This script creates 638a client database and the Service Broker objects for the client services.<o:p></o:p></span></p> 639 640<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 641tab-stops:list .5in' xmlns=""><![if !supportLists]><span style='font-size:13.5pt; 642font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 643color:black'><span style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'> 644</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 645color:black'>Run <span class=SpellE>ServerSetup.sql</span>. This script creates 646a server database and the Service Broker objects for the server service.<o:p></o:p></span></p> 647 648<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 649tab-stops:list .5in' xmlns=""><![if !supportLists]><span style='font-size:13.5pt; 650font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 651color:black'><span style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'> 652</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 653color:black'>Run <span class=SpellE>ClientSendMessages.sql</span> at least 654once. This script creates dialogs and sends messages from Client1Service and 655Client2Service to <span class=SpellE>ServerService</span>.<o:p></o:p></span></p> 656 657<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 658tab-stops:list .5in' xmlns=""><![if !supportLists]><span style='font-size:13.5pt; 659font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 660color:black'><span style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'> 661</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 662color:black'>Run <span class=SpellE>ServerReceiveLoop</span>. This script 663receives and replies to messages sent to <span class=SpellE>ServerService</span>.<o:p></o:p></span></p> 664 665<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 666tab-stops:list .5in'><![if !supportLists]><span style='font-size:13.5pt; 667font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 668color:black'><span style='mso-list:Ignore'>6.<span style='font:7.0pt "Times New Roman"'> 669</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 670color:black'>Run <span class=SpellE>ClientReceiveLoops</span>. This <span 671class=GramE>scripts</span> receives messages sent to Client1Service and 672Client2Service and ends the conversations at the initiator (client) endpoint.<o:p></o:p></span></p> 673 674<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 675tab-stops:list .5in' xmlns=""><![if !supportLists]><span style='font-size:13.5pt; 676font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 677color:black'><span style='mso-list:Ignore'>7.<span style='font:7.0pt "Times New Roman"'> 678</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 679color:black'>Run <span class=SpellE>ServerReceiveLoop</span>. This script ends 680conversations at the target (server) endpoint if an end conversation message is 681received.<o:p></o:p></span></p> 682 683<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 684tab-stops:list .5in'><![if !supportLists]><span style='font-size:13.5pt; 685font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 686color:black'><span style='mso-list:Ignore'>8.<span style='font:7.0pt "Times New Roman"'> 687</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 688color:black'>Repeat steps 4 – 7 as many times as desired.<o:p></o:p></span></p> 689 690<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 691tab-stops:list .5in'><![if !supportLists]><span style='font-size:13.5pt; 692font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 693color:black'><span style='mso-list:Ignore'>9.<span style='font:7.0pt "Times New Roman"'> 694</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 695color:black'>Close all previously used scripts, or make sure that they are not 696using the sample databases. Note that it may take a little time for the 697sample databases to be released after closing the scripts.<o:p></o:p></span></p> 698 699<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 700tab-stops:list .5in'><![if !supportLists]><span style='font-size:13.5pt; 701font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 702color:black'><span style='mso-list:Ignore'>10.<span style='font:7.0pt "Times New Roman"'> 703</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 704color:black'>Run <span class=SpellE>ServerCleanup.sql</span>. This script 705deletes the database that was created for the server service.<o:p></o:p></span></p> 706 707<p style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 lfo4; 708tab-stops:list .5in' xmlns=""><![if !supportLists]><span style='font-size:13.5pt; 709font-family:Verdana;mso-fareast-font-family:Verdana;mso-bidi-font-family:Verdana; 710color:black'><span style='mso-list:Ignore'>11.<span style='font:7.0pt "Times New Roman"'> 711</span></span></span><![endif]><span style='font-size:13.5pt;font-family:Verdana; 712color:black'>Run <span class=SpellE>ClientCleanup.sql</span>. This script 713deletes the database that was created for the client service.<o:p></o:p></span></p> 714 715<h1><span style='font-size:20.5pt;mso-bidi-font-size:13.5pt;font-family:Verdana; 716color:black'></content><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Notes<o:p></o:p></span></h1> 717 718<p style='margin-left:3.75pt'><span style='font-size:13.5pt;font-family:Verdana; 719color:black'>This sample sets up two client services in one database and a server 720service in another database. <o:p></o:p></span></p> 721 722<p style='margin-left:3.75pt'><span style='font-size:13.5pt;font-family:Verdana; 723color:black'>Priority is set to the same values independently in both databases 724because this is believed to be the most common use case. However, it can be set 725to different values in different databases. The user is encouraged to try this 726and see the effects by changing the <span class=SpellE>priority_level</span> 727values in the broker priorities in <span class=SpellE>ClientSetup.sql</span> or 728<span class=SpellE>ServerSetup.sql</span>.<o:p></o:p></span></p> 729 730<p style='margin-left:3.75pt'><span style='font-size:13.5pt;font-family:Verdana; 731color:black'>Priority always affects the order of message receives. This is 732clearly shown in this sample.<o:p></o:p></span></p> 733 734<p style='margin-left:3.75pt'><span style='font-size:13.5pt;font-family:Verdana; 735color:black'>Priority only affects the order of sends if the initiator and 736target endpoints are on different computers or SQL Server instances (except in 737error cases). So it is not clearly seen in this sample. However, the steps to 738set up priority for cross computer or cross instance messaging are identical to 739the steps in this sample—there are no additional steps related to priority. <o:p></o:p></span></p> 740 741<p style='margin-left:3.75pt'><span style='font-size:13.5pt;font-family:Verdana; 742color:black'>The scripts in this sample are separated between client and server 743scripts to allow use on separate computers or SQL Server instances. However, to 744support this, the user needs to add routes, master keys, permissions, and 745ensure connectivity between the instances.<o:p></o:p></span></p> 746 747</div> 748 749</div> 750 751</div> 752 753<div id=footer> 754 755<p class=MsoNormal><span style='font-size:13.5pt;font-family:Verdana; 756color:black'>© 2007 Microsoft Corporation. All rights reserved. <o:p></o:p></span></p> 757 758</div> 759 760</div> 761 762</div> 763 764</body> 765 766</html>