PageSourceSearch

https://lifeasbob.com/Code/kb_articles.aspx?article_Id=65&CatId=41

html lifeasbob.com collected 2026-10-06 22:06:23 UTC 36,275 bytes, 321 lines download raw bytes

1
2<html xmlns="http://www.w3.org/1999/xhtml" >
3<head id="Head1">
4<link rel="SHORTCUT ICON" type="image/x-icon" href="http://www.lifeasbob.com/favicon.ico" />
5<title>
6	Bob Knowledge
7</title></head>
8<body>
9    <form method="post" action="./kb_articles.aspx?article_Id=65&amp;CatId=41" id="form1">
10<div class="aspNetHidden">
11<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
12<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
13<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMTkwOTU0OTg2NQ9kFgJmD2QWAgIDD2QWCAIBDw8WAh4EVGV4dAUNU2Vzc2lvbnM6IDQzNGRkAgMPDxYCHwAFGFR1ZXNkYXksIE9jdG9iZXIgNiwgMjAyNmRkAgUPZBYKAicPDxYCHwAFJEZhbWlseV9QaWN0dXJlX1NlcHRlbWJlcl8yMDA3XzQxLkpQR2RkAikPDxYCHgtOYXZpZ2F0ZVVybAVcfi9DYW1lcmEvRGVmYXVsdC5hc3B4P21lZGlhX3Nlcmllc2lkPTQwJm1lZGlhX25hbWU9MTAyMX5GYW1pbHlfUGljdHVyZV9TZXB0ZW1iZXJfMjAwN180MS5KUEdkFgJmDw8WAh4ISW1hZ2VVcmwFRH4vQ2FtZXJhL1VwbG9hZHMvU2VyaWVzfjQwLzEwMjF+RmFtaWx5X1BpY3R1cmVfU2VwdGVtYmVyXzIwMDdfNDEuSlBHZGQCLQ8PFgYfAQWkAWh0dHA6Ly93d3cuTGlmZUFzQm9iLmNvbS9MaW5rcy9MYXVuY2hMaW5rLmFzcHg/TGlua0lkPTM0NiZsaW5rdXJsPWh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9pc2FwaS9yZWRpci5kbGw/cHJkPVdpbmRvd3Mmc2JwPU1lZGlhUGxheWVyJmFyPUZhdm9yaXRlJnNiYT1DTkVUJnB2ZXI9Ni4yHwAFF0NORVQgVG9kYXkgLSBUZWNobm9sLi4uHgZUYXJnZXQFBF9uZXdkZAIvDw8WBB8ABb8BSSB0aHJvdyBhIGxpdHRsZSBkcnkgbWFsdCwgd2hpY2ggaXMgbGVmdCBvZiBwdXJwb3NlLCBvbiB0b3Agb2YgdGhlIG1hc2gsIHdpdGggYSBoYW5kZnVsIG9mIHNhbHQsIHRvIGtlZXAgdGhlIHdpdGNoZXMgZnJvbSBpdCwgYW5kIHRoZW4gY292ZXIgaXQgdXAuIC0gSW5zdHJ1Y3Rpb25zIGZvciBicmV3aW5nIFNjb3RjaCBBbGUsIDE3OTMeB1Zpc2libGVnZGQCMQ8PFgIfAAUENjAyNGRkAgcPZBYCAgEPZBYWAgEPDxYCHwRoZGQCCQ8PFgIfBGhkZAINDw8WAh8ABbEZPGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9NDAiPkNsdXN0ZXI8L2E+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzUiPkRPUzwvYT48YnIgLz48aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0zMyI+SUJNIC0gQVM0MDA8L2E+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MTciPk1PTTwvYT48YnIgLz48aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xMCI+UGVyZm9ybWFuY2UgQ291bnRlcnM8L2E+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzkiPlNlcnZpY2UgQnJva2VyPC9hPjxiciAvPjxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9PcGVuQm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xIj5TUUwgU2VydmVyPC9hPjxiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTIiPlRlbXBvcmFyeSBEYXRhYmFzZTwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0zIj5WaWV3czwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD01Ij5CYWNrdXA8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9NiI+U1FMIE1haWw8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9NyI+RFRTIC0gRGF0YSBUcmFuc2Zvcm1hdGlvbiBTZXJ2aWNlczwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD04Ij5NZW1vcnk8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9OSI+U2VjdXJpdHk8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MTEiPkV4Y2VsPC9hPjxiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTEyIj5Kb2JzIFNRTCBBZ2VudDwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xMyI+TVNERTwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xNCI+SW5zdGFsbDwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xNSI+REJDQzwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvQ2xvc2VkYm9vay5naWYiIC8+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD0xNiI+VXNlciBNYW5hZ2VtZW50PC9hPjxiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTM0Ij5TeXN0ZW0gRGF0YWJhc2VzPC9hPj
13xiciAvPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOzxpbWcgc3JjPSIuLi9JbWFnZXMvVHJlZS9DbG9zZWRib29rLmdpZiIgLz48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTM3Ij5CQ1Y8L2E+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzgiPkRlYWRsb2NrczwvYT48YnIgLz4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs8aW1nIHNyYz0iLi4vSW1hZ2VzL1RyZWUvT3BlbkJvb2suZ2lmIiAvPjxzcGFuIHN0eWxlPSJiYWNrZ3JvdW5kLWNvbG9yOiAjRkZGRjY2Ij48YSBocmVmPSJrYl9hcnRpY2xlcy5hc3B4P0NhdElkPTQxIj5UZW1wIFRhYmxlczwvYT48L3NwYW4+PGJyIC8+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL1RvcGljLmdpZiIgLz48c3BhbiBzdHlsZT0iYmFja2dyb3VuZC1jb2xvcjogI0ZGRkY2NiI+PGEgaHJlZj0ia2JfYXJ0aWNsZXMuYXNweD9DYXRJZD00MSZBcnRpY2xlX2lkPTY1Ij5XaGVuIHRvIFVzZSBUZW1wIFRhYi4uLjwvYT48L3NwYW4+PGJyIC8+PGltZyBzcmM9Ii4uL0ltYWdlcy9UcmVlL0Nsb3NlZGJvb2suZ2lmIiAvPjxhIGhyZWY9ImtiX2FydGljbGVzLmFzcHg/Q2F0SWQ9MzYiPldpbmRvd3MgT1M8L2E+ZGQCDw8PFgIfBGhkZAIVDw8WAh8ABS9XaWxsIGJlIGFkZGVkIGFzIGEgc3ViLWNhdGVnb3J5IG9mLCBUZW1wIFRhYmxlc2RkAhkPDxYCHwAFJVdoZW4gdG8gVXNlIFRlbXAgVGFibGVzIGluIFNRTCBTZXJ2ZXJkZAIbDxAPFgIeC18hRGF0YUJvdW5kZ2QQFRoGQmFja3VwA0JDVgdDbHVzdGVyBERCQ0MJRGVhZGxvY2tzG0Rpc3RyaWJ1dGVkIFBhcnRpb25lZCBWaWV3cwNET1MiRFRTIC0gRGF0YSBUcmFuc2Zvcm1hdGlvbiBTZXJ2aWNlcwVFeGNlbAtJQk0gLSBBUzQwMAdJbnN0YWxsDkpvYnMgU1FMIEFnZW50Bk1lbW9yeQNNT00ETVNERRRQZXJmb3JtYW5jZSBDb3VudGVycwhTZWN1cml0eQ5TZXJ2aWNlIEJyb2tlcghTUUwgTWFpbApTUUwgU2VydmVyEFN5c3RlbSBEYXRhYmFzZXMLVGVtcCBUYWJsZXMSVGVtcG9yYXJ5IERhdGFiYXNlD1VzZXIgTWFuYWdlbWVudAVWaWV3cwpXaW5kb3dzIE9TFRoBNQIzNwI0MAIxNQIzOAE0AjM1ATcCMTECMzMCMTQCMTIBOAIxNwIxMwIxMAE5AjM5ATYBMQIzNAI0MQEyAjE2ATMCMzYUKwMaZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2cWAWZkAh8PDxYCHwAF1xs8UD5Zb3VyIHF1ZXN0aW9uIHNob3dzIHlvdSBoYXZlIHN1Y2N1bWJlZCB0byBzb21lIG9mIHRoZSBjb21tb24gbWlzY29uY2VwdGlvbnMgc3Vycm91bmRpbmcgdGFibGUgdmFyaWFibGVzIGFuZCB0ZW1wb3JhcnkgdGFibGVzLjwvUD4NCjxQPkkgaGF2ZSB3cml0dGVuIDxBIGhyZWY9Imh0dHA6Ly9kYmEuc3RhY2tleGNoYW5nZS5jb20vcXVlc3Rpb25zLzE2Mzg1L3doYXRzLXRoZS1kaWZmZXJlbmNlLWJldHdlZW4tYS10ZW1wLXRhYmxlLWFuZC10YWJsZS12YXJpYWJsZS1pbi1zcWwtc2VydmVyLzE2Mzg2IzE2Mzg2Ij5xdWl0ZSBhbiBleHRlbnNpdmUgYW5zd2VyIG9uIHRoZSBEQkEgc2l0ZTwvQT4gbG9va2luZyBhdCB0aGUgZGlmZmVyZW5jZXMgYmV0d2VlbiB0aGUgdHdvIG9iamVjdCB0eXBlcy4gVGhpcyBhbHNvIGFkZHJlc3NlcyB5b3VyIHF1ZXN0aW9uIGFib3V0IGRpc2MgdnMgbWVtb3J5IChJIGRpZG4ndCBzZWUgYW55IHNpZ25pZmljYW50IGRpZmZlcmVuY2UgaW4gYmVoYXZpb3VyIGJldHdlZW4gdGhlIHR3bykuPC9QPg0KPFA+UmVnYXJkaW5nIHRoZSBxdWVzdGlvbiBpbiB0aGUgdGl0bGUgdGhvdWdoIGFzIHRvIHdoZW4gdG8gdXNlIGEgdGFibGUgdmFyaWFibGUgdnMgYSBsb2NhbCB0ZW1wb3JhcnkgdGFibGUgeW91IGRvbid0IGFsd2F5cyBoYXZlIGEgY2hvaWNlLiBJbiBmdW5jdGlvbnMgZm9yIGV4YW1wbGUgaXQgaXMgb25seSBwb3NzaWJsZSB0byB1c2UgYSB0YWJsZSB2YXJpYWJsZSBhbmQgaWYgeW91IG5lZWQgdG8gcmVmZXJlbmNlIHRoZSBvYmplY3QgaW4gYSBjaGlsZCBzY29wZSB0aGVuIG9ubHkgYSA8Q09ERT4jdGVtcDwvQ09ERT4gdGFibGUgd2lsbCBkby4gV2hlcmUgeW91IGRvIGhhdmUgYSBjaG9pY2Ugc29tZSBzdWdnZXN0aW9ucyBhcmUgYmVsb3cuPC9QPg0KPE9MPg0KPExJPklmIHlvdSBuZWVkIGFuIGluZGV4IHRoYXQgY2Fubm90IGJlIGNyZWF0ZWQgaW1wbGljaXRseSB0aHJvdWdoIGEgPENPREU+VU5JUVVFPC9DT0RFPiBvciA8Q09ERT5QUklNQVJZIEtFWTwvQ09ERT4gY29uc3RyYWludCB0aGVuIHlvdSBuZWVkIGEgPENPREU+I3RlbXBvcmFyeTwvQ09ERT4gdGFibGUgYXMgaXQgaXMgbm90IHBvc3NpYmxlIHRvIGNyZWF0ZSB0aGVzZSBvbiB0YWJsZSB2YXJpYWJsZXMuIChFeGFtcGxlcyBvZiBzdWNoIGluZGV4ZXMgYXJlIG5vbiB1bmlxdWUgb25lcywgZmlsdGVyZWQgaW5kZXhlcyBvciBpbmRleGVzIHdpdGggPENPREU+SU5DTFVERTwvQ09ERT5kIGNvbHVtbnMpLjwvTEk+DQo8TEk+SWYgeW91IHdpbGwgYmUgcmVwZWF0ZWRseSBhZGRpbmcgYW5kIGRlbGV0aW5nIGxhcmdlIG51bWJlcnMgb2Ygcm93cyBmcm9tIHRoZSB0YWJsZSB0aGVuIHVzZSBhIDxDT0RFPiN0ZW1wb3Jhcnk8L0NPREU+IHRhYmxlLiBUaGF0IHN1cHBvcnRzIDxDT0RFPlRSVU5DQVRFPC9DT0RFPiB3aGljaCBpcyBtb3JlIGVmZmljaWVudCB0aGFuIDxDT0RFPkRFTEVURTwvQ09ERT4gYW5kIGFkZGl0aW9uYWxseSBzdWJzZXF1ZW50IGluc2VydHMgZm9sbG93aW5nIGEgPENPREU+VFJVTkNBVEU8L0NPREU+IGNhbiBoYXZlIGJldHRlciBwZXJmb3JtYW5jZSB0aGFuIHRob3NlIGZvbGxvd2luZyBhIDxDT0RFPkRFTEVURTwvQ09ERT4gPEEgaHJlZj0iaHR0cDovL2RiYS5zdGFja2V4Y2hhbmdlLmNvbS9xdWVzdGlvbnMvMjczMDkvd2h5LWRvZXMtZGVsZXRlLWxlYXZlLWEtbGluZ2VyaW5nLWVmZmVjdC1vbi1wZXJmb3JtYW5jZS8yNzMxOSMyNzMxOSI+YXMgaWxsdXN0cmF0ZWQgaGVyZTwvQT4uPC9MST4NCjxMST5JZiB0aGUgb3B0aW1hbCBwbGFuIHVzaW5nIHRoZSB0YWJsZSB3aWxsIHZhcnkgZGVwZW5kZW50IG9uIGRhdGEgdGhlbiB1c2UgYSA8Q09ERT4jdGVtcG9yYXJ5PC9DT0RFPiB0YWJsZS4gVGhhdCBzdXBwb3J0cyBjcmVhdGlvbiBvZiBzdGF0aXN0aWNzIHdoaWNoIGFsbG93cyB0aGUgcGxhbiB0byBiZSBkeW5hbWljYWxseSByZWNvbXBpbGVkIGFjY29yZGluZyB0byB0aGUgZGF0YS48L0xJPg0KPExJPklmIHRoZSBvcHRpbWFsIHBsYW4gZm9yIHRoZSBxdWVyeSB1c2luZyB0aGUgdGFibGUgaXMgdW5saWtlbHkgdG8gZXZlciBjaGFuZ2UgdGhlbiB5b3UgbWF5IGNvbnNpZGVyIGEgdGFibGUgdmFyaWFibGUgdG8gc2tpcCB0aGUgb3ZlcmhlYWQgb2Ygc3RhdGlzdGljcyBjcmVhdGlvbiBhbmQgcmVjb21waWxlcyAoYW5kIHBvc3NpYmx5IHVzZSBvZiBoaW50cyB0byBmaXggdGhlIHBsYW4geW91IHdhbnQpLjwvTEk+DQo8TEk+SWYgdGhlIHNvdXJjZSBmb3IgdGhlIGRhdGEgaW5zZXJ0ZWQgdG8gdGhlIHRhYmxlIGlzIGZyb20gYSBwb3RlbnRpYWxseSBleHBlbnNpdmUgPENPREU+U0VMRUNUPC9DT0RFPiBzdGF0ZW1lbnQgdGhlbiBjb25zaWRlciB0aGF0IHVzaW5nIGEgdGFibGUgdmFyaWFibGUgd2lsbCBibG9jayB0aGUgcG9zc2liaWxpdHkgb2YgdGhpcyB1c2luZyBhIHBhcmFsbGVsIHBsYW4uPC9MST4NCjxMST5JZiB5b3UgbmVlZCB0aGUgZGF0YSBpbiB0aGUgdGFibGUgdG8gc3Vydml2ZSBhIHJvbGxiYWNrIG9mIGFuIG91dGVyIHVzZXIgdHJhbnNhY3Rpb24gdGhlbiB1c2UgYSB0YWJsZSB2Y
13XJpYWJsZS4gQSBwb3NzaWJsZSB1c2UgY2FzZSBmb3IgdGhpcyBtaWdodCBiZSBsb2dnaW5nIHByb2dyZXNzIG9mIGRpZmZlcmVudCBzdGVwcyBpbiBhIGxvbmcgU1FMIGJhdGNoLjwvTEk+DQo8TEk+V2hlbiB1c2luZyBhIDxDT0RFPiN0ZW1wPC9DT0RFPiB0YWJsZSB3aXRoaW4gYSB1c2VyIHRyYW5zYWN0aW9uIGxvY2tzIGFyZSBoZWxkIGxvbmdlciB0aGFuIGZvciB0YWJsZSB2YXJpYWJsZXMgYW5kIGFsc28gaXQgY2FuIHByZXZlbnQgdHJ1bmNhdGlvbiBvZiB0aGUgPENPREU+dGVtcGRiPC9DT0RFPiB0cmFuc2FjdGlvbiBsb2cgdW50aWwgdGhlIHVzZXIgdHJhbnNhY3Rpb24gZW5kcy4gU28gdGhpcyBtaWdodCBmYXZvdXIgdGhlIHVzZSBvZiB0YWJsZSB2YXJpYWJsZXMuPC9MST4NCjxMST5XaXRoaW4gc3RvcmVkIHJvdXRpbmVzIGJvdGggdGFibGUgdmFyaWFibGVzIGFuZCB0ZW1wb3JhcnkgdGFibGVzIGNhbiBiZSBjYWNoZWQuIFRoZSBtZXRhZGF0YSBtYWludGVuYW5jZSBmb3IgY2FjaGVkIHRhYmxlIHZhcmlhYmxlcyBpcyBsZXNzIHRoYW4gdGhhdCBmb3IgPENPREU+I3RlbXBvcmFyeTwvQ09ERT4gdGFibGVzLiBCb2IgV2FyZCBwb2ludHMgb3V0IGluIGhpcyA8QSBocmVmPSJodHRwOi8vd3d3LnlvdXR1YmUuY29tL3dhdGNoP3Y9U3ZzZUdNb2JlMnciIHJlbD1ub2ZvbGxvdz48Q09ERT50ZW1wZGI8L0NPREU+IHByZXNlbnRhdGlvbjwvQT4gdGhhdCB0aGlzIGNhbiBjYXVzZSBhZGRpdGlvbmFsIGNvbnRlbnRpb24gb24gc3lzdGVtIHRhYmxlcyB1bmRlciBjb25kaXRpb25zIG9mIGhpZ2ggY29uY3VycmVuY3kuIEFkZGl0aW9uYWxseSB3aGVuIGRlYWxpbmcgd2l0aCBzbWFsbCBxdWFudGl0aWVzIG9mIGRhdGEgdGhpcyBjYW4gbWFrZSA8QSBocmVmPSJodHRwOi8vZGJhLnN0YWNrZXhjaGFuZ2UuY29tL2EvMTM0MTIvMzY5MCI+YSBtZWFzdXJhYmxlIGRpZmZlcmVuY2UgdG8gcGVyZm9ybWFuY2U8L0E+LjwvTEk+PC9PTD5kZAIhDzwrAAQBARQrAAQUKwACZA8WBARkBGQEZARkFgQUKwACFgoeBVRpdGxlBQlQYXJhZ3JhcGgeCENsaWVudElEBQlQYXJhZ3JhcGgeCWlzQnVpbHRJbmceEUNvbW1hbmRJZGVudGlmaWVyBQtmb3JtYXRCbG9jax4JY2xhc3NOYW1lBQ1QYXJhZ3JhcGhNZW51ZBQrAAIWDB8GBQRGb250HwcFBEZvbnQfCGcfCQUIZm9udG5hbWUeDWJ1aWx0SW5TY3JpcHRlHwoFDUZvbnRGYWNlc01lbnVkFCsAAhYMHwYFBFNpemUfBwUEU2l6ZR8IZx8JBQhmb250c2l6ZR8LZR8KBQ1Gb250U2l6ZXNNZW51ZBQrAAIWDB8GBQVDb2xvch8HBQVDb2xvch8IZx8JBQlmb3JlY29sb3IfC2UfCgUSRm9udEZvcmVDb2xvcnNNZW51ZBQrAAJkDxYIBGIEYgRiBGIEcwRiBGIEYhYIFhAfBgUEQm9sZB8HBQRCb2xkHgtCdXR0b25JbWFnZQUEYm9sZB8IZx4TQnVpbHRJbkJ1dHRvbk9mZnNldGYfCQUEYm9sZB8LZR8KBQRCb2xkFhAfBgUGSXRhbGljHwcFBkl0YWxpYx8MBQZpdGFsaWMfCGcfDQITHwkFBml0YWxpYx8LZR8KBQZJdGFsaWMWEB8GBQlVbmRlcmxpbmUfBwUJVW5kZXJsaW5lHwwFCXVuZGVybGluZR8IZx8NAiUfCQUJdW5kZXJsaW5lHwtlHwoFCVVuZGVybGluZRYQHwYFDVN0cmlrZVRocm91Z2gfBwUNU3RyaWtlVGhyb3VnaB8MBQ1zdHJpa2V0aHJvdWdoHwhnHw0CIh8JBQ1zdHJpa2V0aHJvdWdoHwtlHwoFDVN0cmlrZVRocm91Z2hkFhAfBgULU3VwZXJTY3JpcHQfBwULU3VwZXJTY3JpcHQfDAULc3VwZXJzY3JpcHQfCGcfDQIkHwkFC3N1cGVyc2NyaXB0HwtlHwoFC1N1cGVyU2NyaXB0FhAfBgUJU3ViU2NyaXB0HwcFCVN1YlNjcmlwdB8MBQlzdWJzY3JpcHQfCGcfDQIjHwkFCXN1YnNjcmlwdB8LZR8KBQlTdWJTY3JpcHQWEB8GBRVSZW1vdmUgQWxsIEZvcm1hdHRpbmcfBwUTUmVtb3ZlQWxsRm9ybWF0dGluZx8MBQxyZW1vdmVmb3JtYXQfCGcfDQIfHwkFDHJlbW92ZWZvcm1hdB8LZR8KBQxSZW1vdmVGb3JtYXQUKwACZA8WDgRiBGIEYgRiBHMEYgRiBGIEYgRzBGIEYgRiBGIWDhYQHwYFDEp1c3RpZnkgTGVmdB8HBQtKdXN0aWZ5TGVmdB8MBQtqdXN0aWZ5bGVmdB8IZx8NAhYfCQULanVzdGlmeWxlZnQfC2UfCgULSnVzdGlmeUxlZnQWEB8GBQ1KdXN0aWZ5IFJpZ2h0HwcFDEp1c3RpZnlSaWdodB8MBQxqdXN0aWZ5cmlnaHQfCGcfDQIXHwkFDGp1c3RpZnlyaWdodB8LZR8KBQxKdXN0aWZ5UmlnaHQWEB8GBQ5KdXN0aWZ5IENlbnRlch8HBQ1KdXN0aWZ5Q2VudGVyHwwFDWp1c3RpZnljZW50ZXIfCGcfDQIUHwkFDWp1c3RpZnljZW50ZXIfC2UfCgUNSnVzdGlmeUNlbnRlchYQHwYFDEp1c3RpZnkgRnVsbB8HBQtKdXN0aWZ5RnVsbB8MBQtqdXN0aWZ5ZnVsbB8IZx8NAhUfCQULanVzdGlmeWZ1bGwfC2UfCgULSnVzdGlmeUZ1bGxkFhAfBgUNQnVsbGV0ZWQgTGlzdB8HBQxCdWxsZXRlZExpc3QfDAUMYnVsbGV0ZWRsaXN0HwhnHw0CAR8JBRNpbnNlcnR1bm9yZGVyZWRsaXN0HwtlHwoFDEJ1bGxldGVkTGlzdBYQHwYFDU51bWJlcmVkIExpc3QfBwUMTnVtYmVyZWRMaXN0HwwFDG51bWJlcmVkbGlzdB8IZx8NAhofCQURaW5zZXJ0b3JkZXJlZGxpc3QfC2UfCgUMTnVtYmVyZWRMaXN0FhAfBgUGSW5kZW50HwcFBkluZGVudB8MBQZpbmRlbnQfCGcfDQIKHwkFBmluZGVudB8LZR8KBQZJbmRlbnQWEB8GBQdPdXRkZW50HwcFB091dGRlbnQfDAUHb3V0ZGVudB8IZx8NAhsfCQUHb3V0ZGVudB8LZR8KBQdPdXRkZW50ZBYQHwYFC0NyZWF0ZSBMaW5rHwcFCkNyZWF0ZUxpbmsfDAUKY3JlYXRlbGluax8IZx8NAgMfCQUKY3JlYXRlbGluax8LBRZ0aGlzLmZ0Yi5DcmVhdGVMaW5rKCk7HwoFCkNyZWF0ZUxpbmsWEh8IZx8GBQZVbmxpbmsfDAUGdW5saW5rHwtlHwkFBnVubGluax8HBQZVbmxpbmsfCgUGVW5saW5rHhRidWlsdEluRW5hYmxlZFNjcmlwdAWLAXZhciBlbCA9IHRoaXMuZnRiLkdldFBhcmVudEVsZW1lbnQoKTsgaWYgKGVsLnRhZ05hbWUgJiYgZWwudGFnTmFtZS50b0xvd2VyQ2FzZSgpICE9ICdhJykgdGhpcy5kaXNhYmxlZCA9IHRydWU7IGVsc2UgdGhpcy5kaXNhYmxlZCA9IGZhbHNlOyAfDQInFhAfBgUMSW5zZXJ0IEltYWdlHwcFC0luc2VydEltYWdlHwwFC2luc2VydGltYWdlHwhnHwkFC2luc2VydGltYWdlHw0CDB8LBRd0aGlzLmZ0Yi5JbnNlcnRJbWFnZSgpOx8KBQtJbnNlcnRJbWFnZRYQHwYFC0luc2VydCBSdWxlHwcFCkluc2VydFJ1bGUfDAUKaW5zZXJ0cnVsZR8IZx8NAg4fCQUUaW5zZXJ0aG9yaXpvbn
13RhbHJ1bGUfC2UfCgUKSW5zZXJ0UnVsZRQrAAJkDxYHBGIEYgRiBHMEYgRiBGIWBxYQHwYFA0N1dB8HBQNDdXQfDAUDY3V0HwhnHwkFA2N1dB8NAgQfCwUPdGhpcy5mdGIuQ3V0KCk7HwoFA0N1dBYQHwYFBENvcHkfBwUEQ29weR8MBQRjb3B5HwhnHwkFBGNvcHkfDQICHwsFEHRoaXMuZnRiLkNvcHkoKTsfCgUEQ29weRYQHwYFBVBhc3RlHwcFBVBhc3RlHwwFBXBhc3RlHwhnHwkFBXBhc3RlHw0CHB8LBRF0aGlzLmZ0Yi5QYXN0ZSgpOx8KBQVQYXN0ZWQWEh8IZx8GBQRVbmRvHwwFBHVuZG8fCwUQdGhpcy5mdGIuVW5kbygpOx8JBQR1bmRvHwcFBFVuZG8fCgUEVW5kbx8OBSJ0aGlzLmRpc2FibGVkPSF0aGlzLmZ0Yi5DYW5VbmRvKCk7Hw0CJhYSHwhnHwYFBFJlZG8fDAUEcmVkbx8LBRB0aGlzLmZ0Yi5SZWRvKCk7HwkFBHJlZG8fBwUEUmVkbx8KBQRSZWRvHw4FInRoaXMuZGlzYWJsZWQ9IXRoaXMuZnRiLkNhblJlZG8oKTsfDQIeFhAfBgUFUHJpbnQfBwUFUHJpbnQfDAUFcHJpbnQfCGcfDQIdHwkFBXByaW50HwsFEXRoaXMuZnRiLlByaW50KCk7HwoFBVByaW50ZAInDw8WAh8EaGRkAikPDxYCHwRoZGRknbgrcYVxFs/56korngOWIyONFyxziE4Yrjzw+8jdvC8=" />
14</div>
15
16<script type="text/javascript">
17//<![CDATA[
18var theForm = document.forms['form1'];
19if (!theForm) {
20    theForm = document.form1;
21}
22function __doPostBack(eventTarget, eventArgument) {
23    if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
24        theForm.__EVENTTARGET.value = eventTarget;
25        theForm.__EVENTARGUMENT.value = eventArgument;
26        theForm.submit();
27    }
28}
29//]]>
30</script>
30
31
32
33<div class="aspNetHidden">
34
35	<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="B7FFFDA2" />
36</div>
37    <div>
38			<table border="0" cellpadding="6" width="95%">
39				<tr>
40                    <td style="text-align:left"><span id="lblSessions" style="color: #6699FF; font-style: italic; font-family: Verdana; font-size: x-small">Sessions: 434</span></td>
41				    <td colspan="2" align="right" style="height: 3px">
42                        <span style="font-family: Stencil"><span style="color: #660066"><span style="font-size: 7pt;
43                            font-family: Verdana">
44    				    The postings on this site are my own and do not represent my Employer's positions, advice or strategies.</span> </span></span>
45				    </td>
46				</tr>
47				<tr>
48					<td style="white-space: nowrap" align="left" width="33%">
49						<p align="left"><i> <font color="#3399ff" size="6" face="Verdana">
50                                        <b>LifeAsBob</b>
51								</font></i>
52						</p>
53					</td>
54					<td width="33%" align="right">
55                        <input type="text" id="q" name="q" size="15" onkeypress="return submitenter(this,event)" />&nbsp;
56                        <input type="button" name="sa" value="Search LifeAsBob" onclick="SearchSite();" />  					
57					</td>
58					<td width="33%" align="left"><font face="Verdana" size="2"><b>
59								<span id="lblTimeStamp">Tuesday, October 6, 2026</span>
60							</b></font>
61						<br/>
62					</td>
63				</tr>
64			</table>
65			<table align="left" border="5" cellspacing="0" width="95%" cellpadding="4">
66				<tr>
67					<td id="menuColumn" width="33%" valign="top" align="left">
68											<table id="Table4" width="100%" bgcolor="#3399ff" border="0">
69												<tr>
70													<td bgcolor="#ffff00">
71														<p align="left"><font face="Verdana" size="2"><b><font color="#ffff00">
72                                                         <img id="Image1" src="../images/blank.gif" style="border-width:0px;height:5px;width:5px;" />
73                                                        </font></b>lifeasbob.com</font></p>
74													</td>
75												</tr>
76												<tr>
77													<td valign="top" bgcolor="#3399ff">
78														<p align="left"><font face="Verdana" size="1"><br/>
79																	<!--
80                                                                    <a href="http://edit.yahoo.com/config/send_webmesg?.target=BusTravelerKC&amp;.src=pg">
81																		<img src="http://opi.yahoo.com/online?u=BusTravelerKC&amp;m=g&amp;t=2" border="0" alt="" /></a><br/>
82																	<br/>
83                                                                    -->
84                                                                    <img id="Image2" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
85                                                                    </font><font size="2">
86																	<a id="lnkMain" href="../Default.aspx">Home</a>
87																	<br/>
88                                                                    <img id="Image3" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
89																		<a id="lnkBlog" href="../BobsBlog/MainBlog.aspx">Blog</a>
90																	<br/>
91                                                                    <img id="Image4" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
92																	    <a id="lnkCode" href="Default.aspx">bob tech</a>
93                													<br />
94                                                                        <img id="Image5" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
95																		<a id="lnkCalendar" href="../Events/Calendar.aspx">Calendar</a>
96																	<br/>
97                                                                        <img id="Image6" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
98																	    <a id="lnkContact" href="../Contact.aspx">
98Contact Bob</a>
99																	<br/>
100                                                                        <img id="Image7" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
101																	    <a id="lnkPictures" href="../Camera/Default.aspx">Pictures</a>
102                                                                    <br/>
103                                                                        <img id="Image8" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
104																	    <a id="lnkBuses" href="../VWBuses/Default.aspx">VW Buses</a>
105                                                                    <br/>
106                                                                        <img id="Image9" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
107																	    <a id="lnkHomeBrew" href="../HomeBrew/Default.aspx">HomeBrew</a>
108                                                                    <br/>
109                                                                        <img id="Image10" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
110																	    <a id="lnkRecipe" href="../Recipe/Default.aspx">Cook Book</a>
111                                                                    </font>
112														</p>
113														<p align="left">&nbsp;</p>
114														</td>
115												</tr>
116												</table>
117						<table align="left" border="1" width="100%">
118							<tr>
119								<td align="left">
120								<p>
121    								<span id="lblMasterPic">Family_Picture_September_2007_41.JPG</span><br />
122    								<a id="lnkPic" href="../Camera/Default.aspx?media_seriesid=40&amp;media_name=1021~Family_Picture_September_2007_41.JPG"><img id="imgMasterPic" src="../Camera/Uploads/Series~40/1021~Family_Picture_September_2007_41.JPG" align="absmiddle" style="height:120px;" /></a>
123                                </p>
124								</td>
125							</tr>
126							<tr>
127							    <td valign="top" bgcolor="#ffff00">
128                                <img id="Image11" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
129                                &nbsp;
130								<a title="bob Links" href="/Links/default.asp">bob Links </a>
131							    </td>
132    						</tr>
133    						<tr>
134							    <td valign="top" bgcolor="#ffff00" height="20">
135								    <a id="lnkRandom" href="http://www.LifeAsBob.com/Links/LaunchLink.aspx?LinkId=346&amp;linkurl=http://www.microsoft.com/isapi/redir.dll?prd=Windows&amp;sbp=MediaPlayer&amp;ar=Favorite&amp;sba=CNET&amp;pver=6.2" target="_new">CNET Today - Technol...</a>
136								</td>
137      						</tr>
138    						<tr>
139							    <td valign="top" bgcolor="3399ff" >
140								    <span id="txtBeerQuote">I throw a little dry malt, which is left of purpose, on top of the mash, with a handful of salt, to keep the witches from it, and then cover it up. - Instructions for brewing Scotch Ale, 1793</span>
141								</td>
142      						</tr>
143    						<tr> 
144							    <td style="vertical-align:middle; background-color:#3399FF; text-align:right">
145    								Bob Code
146                                    <span id="lblBobCode">6024</span>
147								</td>
148      						</tr>
149      						<tr>
150      						    <td>
151                                <!--
152      						        
152<script type="text/javascript" src="http://feedjit.com/serve/?bc=ffffff&amp;tc=494949&amp;brd1=336699&amp;lnk=494949&amp;hc=336699&amp;ww=160"></script>
152<noscript><a href="http://feedjit.com/">Feedjit Live Website Statistics</a></noscript>
153      						    -->
154                                    <img id="Image12" src="../images/bul.gif" style="border-width:0px;height:7px;width:7px;" />
155                                    <a id="lnkThings" href="../BobThings/BobViewThings.aspx">Things</a>
156                                </td>
157      						</tr>
158						</table>
159					</td>
160
161					<td id="contentColumn" width="67%" align="left" valign="top">
162                        
163	<table>
164	    <tr>
165            <td colspan="2">
166                
167            </td>	        
168        </tr>
169	    <tr>
170	        <td colspan="2">
171	        <table>
172	            <tr>
173	                <td align="left">
174	        	        <a id="MainContent_lnkPrint" href="javascript:__doPostBack(&#39;ctl00$MainContent$lnkPrint&#39;,&#39;&#39;)">Wider View</a>
175	                </td>
176	                <td align="center">
177                        <input name="ctl00$MainContent$txtSearchPhrase" type="text" id="MainContent_txtSearchPhrase" />
178                        <input type="submit" name="ctl00$MainContent$cmdFilter" value="Search" id="MainContent_cmdFilter" />	                
179	                </td>
180	                <td align="right">
181                        
182	                    <input type="hidden" name="ctl00$MainContent$hiddenInsertOn" id="MainContent_hiddenInsertOn" value="false" />
183	                </td>
184                    <td style="text-align:right">
185                        <a href="../UserMgmt/login.aspx?ReturnLink=../Code/KB_Articles.aspx">Login</a>
186                    </td>
187	            </tr>
188	        </table>
189	        </td>
190	    </tr>
191	</table>
192	<table align="left" border="1">
193		<tr>
194			<td valign="top" align="left">
195                     <font style="font-family: Verdana; font-size:small" face="Verdana">
196                        <span id="MainContent_lblMyTree"><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=40">Cluster</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=35">DOS</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=33">IBM - AS400</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=17">MOM</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=10">Performance Counters</a><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=39">Service Broker</a><br /><img src="../Images/Tree/OpenBook.gif" /><a href="kb_articles.aspx?CatId=1">SQL Server</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=2">Temporary Database</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=3">Views</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=5">Backup</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=6">SQL Mail</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=7">DTS - Data Transformation Services</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=8">Memory</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=9">Security</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=11">Excel</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=12">Jobs SQL Agent</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=13">MSDE</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=14">Install</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=15">DBCC</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=16">User Management</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=34">System Databases</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=37">BCV</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=38">Deadlocks</a><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/OpenBook.gif" /><span style="background-color: #FFFF66"><a href="kb_articles.aspx?CatId=41">Temp Tables</a></span><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../Images/Tree/Topic.gif" /><span style="background-color: #FFFF66"><a href="kb_articles.aspx?CatId=41&Article_id=65">When to Use Temp Tab...</a></span><br /><img src="../Images/Tree/Closedbook.gif" /><a href="kb_articles.aspx?CatId=36">Windows OS</a></span>
197                     </font>
198                     <br /> 
199                     <hr />
200       			    
201                     <br />
202                     <input name="ctl00$MainContent$txtNewCategory" type="text" id="MainContent_txtNewCategory" />
203                     <br />
204                     <font size="1" color="#999999" style="font-family: Verdana" face="Verdana">
205                        <input type="hidden" name="ctl00$MainContent$selectedCategory" id="MainContent_selectedCategory" value="41" />
206                        <span id="MainContent_lblcategoryDesc">Will be added as a sub-category of, Temp Tables</span>
207                    </font>
208                </td>
209            <td valign="top" align="left">
210                <table border="2">
211                    <tr>
212                        <td bgcolor="#3399FF" style="height: 21px">
213                            <input type="hidden" name="ctl00$MainContent$hiddenArticleId" id="MainContent_hiddenArticleId" value="65" />
214                            <span id="MainContent_lblSubject">When to Use Temp Tables in SQL Server</span>
215							
216							
217                        </td>
218                    </tr>
219                    <tr>
220                        <td style="border-color:#3399FF; height: 21px">
221                        	<span id="MainContent_lblResults"><P>Your question shows you have succumbed to some of the common misconceptions surrounding table variables and temporary tables.</P>
222<P>I have written <A href="http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server/16386#16386">quite an extensive answer on the DBA site</A> looking at the differences between the two object types. This also addresses your question about disc vs memory (I didn't see any significant difference in behaviour between the two).</P>
223<P>Regarding the question in the title though as to when to use a table variable vs a local temporary table you don't always have a choice. In functions for example it is only possible to use a table variable and if you need to reference the object in a child scope then only a <CODE>#temp</CODE> table will do. Where you do have a choice some suggestions are below.</P>
224<OL>
225<LI>If you need an index that cannot be created implicitly through a <CODE>UNIQUE</CODE> or <CODE>PRIMARY KEY</CODE> constraint then you need a <CODE>#temporary</CODE> table as it is not possible to create these on table variables. (Examples of such indexes are non unique ones, filtered indexes or indexes with <CODE>INCLUDE</CODE>d columns).</LI>
226<LI>If you will be repeatedly adding and deleting large numbers of rows from the table then use a <CODE>#temporary</CODE> table. That supports <CODE>TRUNCATE</CODE> which is more efficient than <CODE>DELETE</CODE> and additionally subsequent inserts following a <CODE>TRUNCATE</CODE> can have better performance than those following a <CODE>DELETE</CODE> <A href="http://dba.stackexchange.com/questions/27309/why-does-delete-leave-a-lingering-effect-on-performance/27319#27319">as illustrated here</A>.</LI>
227<LI>If the optimal plan using the table will vary dependent on data then use a <CODE>#temporary</CODE> table. That supports creation of statistics which allows the plan to be dynamically recompiled according to the data.</LI>
228<LI>If the optimal plan for the query using the table is unlikely to ever change then you may consider a table variable to skip the overhead of statistics creation and recompiles (and possibly use of hints to fix the plan you want).</LI>
229<LI>If the source for the data inserted to the table is from a potentially expensive <CODE>SELECT</CODE> statement then consider that using a table variable will block the possibility of this using a parallel plan.</LI>
230<LI>If you need the data in the table to survive a rollback of an outer user transaction then use a table variable. A possible use case for this might be logging progress of different steps in a long SQL batch.</LI>
231<LI>When using a <CODE>#temp</CODE> table within a user transaction locks are held longer than for table variables and also it can prevent truncation of the <CODE>tempdb</CODE> transaction log until the user transaction ends. So this might favour the use of table variables.</LI>
232<LI>Within stored routines both table variables and temporary tables can be cached. The metadata maintenance for cached table variables is less than that for <CODE>#temporary</CODE> tables. Bob Ward points out in his <A href="http://www.youtube.com/watch?v=SvseGMobe2w" rel=nofollow><CODE>tempdb</CODE> presentation</A> that this can cause additional contention on system tables under conditions of high concurrency. Additionally when dealing with small quantities of data this can make <A href="http://dba.stackexchange.com/a/13412/3690">a measurable difference to performance</A>.</LI></OL></span>
233							
234                        </td>
235                    </tr>
236                    <tr>
237                        <td align="right">
238                            
239                            
240                            
241                            
242                        </td>
243                    </tr>
244                    
245                </table>
246			</td>
247		</tr>
248	</table>
249					
250					</td>
251
252				</tr>
253				<tr>
254					<td colspan="2">
255                                                
256                        
257
258					</td>
259				</tr>
260			</table>        
261        
262    </div>
263    
263<script type="text/javascript">
264        // Function retrieved from: http://cass- hacks.com/articles/code/js_url_encode_decode/   
265        function URLEncode(clearString) {
266            var output = '';
267            var x = 0;
268            clearString = clearString.toString();
269            var regex = /(^[a-zA-Z0-9_.]*)/;
270            while (x < clearString.length) {
271                var match = regex.exec(clearString.substr(x));
272                if (match != null && match.length > 1 && match[1] != '') {
273                    output += match[1];
274                    x += match[1].length;
275                } else {
276                    if (clearString[x] == ' ')
277                        output += '+';
278                    else {
279                        var charCode = clearString.charCodeAt(x);
280                        var hexVal = charCode.toString(16);
281                        output += '%' + (hexVal.length < 2 ? '0' : '') + hexVal.toUpperCase();
282                    }
283                    x++;
284                }
285            }
286            return output;
287        }
288        // Retrieved from: http://www.htmlcodetutorial.com/forms/index_famsupp_157.html   
289        function SubmitOnEnter(myfield, e) {
290            var keycode;
291            if (window.event)
292                keycode = window.event.keyCode;
293            else if (e)
294                keycode = e.which;
295            else
296                return true;
297            if (keycode == 13) {
298                SearchSite();
299                return false;
300            }
301            else
302                return true;
303        }
304        function SearchSite() {
305            document.location.href = 'https://www.lifeasbob.com/SearchResults.aspx?cx=002008443492709312896%3Abxirmyphx8e&cof=FORID%3A11&ie=UTF-8&q=' +
306URLEncode(document.getElementById('q').value) + '&sa=Search';
307        }  
308    </script>
308      
309<!-- Global site tag (gtag.js) - Google Analytics -->
vendor: 82 bytes, lines 309-310
309
310<script type="text/javascript" src="https://www.googletagmanager.com/gtag/js?id=
310G-FRJQ88TDFW
vendor: 19 bytes, line 310
310" async></script>
311<script type="text/javascript">
312    
vendor: 147 bytes, lines 312-316
312window.dataLayer = window.dataLayer || [];
313    function gtag() { dataLayer.push(arguments); }
314    gtag('js', new Date());
315
316    gtag('config', '
316G-FRJQ88TDFW
vendor: 5 bytes, line 316
316');
317</script>
317
318
319    </form>
320</body>
321</html>

Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.