PageRenderTime 669ms CodeModel.GetById 12ms RepoModel.GetById 0ms app.codeStats 0ms

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