<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://msmvps.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd"><channel><title>MSMVPS.COM</title><link>http://msmvps.com/blogs/</link><description>The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
</description><dc:language>en-US</dc:language><generator>CommunityServer 2008.5 SP2 (Build: 40407.4157)</generator><item><title>And indeed...exactly 7 days after you DCpromo down your old SBS 2003....</title><link>http://msmvps.com/blogs/bradley/archive/2009/12/10/and-indeed-exactly-7-days-after-you-dcpromo-down-your-old-sbs-2003.aspx</link><pubDate>Fri, 11 Dec 2009 04:56:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744764</guid><dc:creator>bradley</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;And indeed...exactly 7 days after you DCpromo down your old SBS 2003....&lt;/p&gt;
&lt;p&gt;it shuts down....&lt;/p&gt;
&lt;p&gt;
&lt;tr&gt;
&lt;/tr&gt;
&lt;td width="15%"&gt;&lt;/td&gt;
EVENT #
&lt;td width="85%"&gt;&lt;/td&gt;
485427 
&lt;tr&gt;
&lt;/tr&gt;
&lt;td width="15%"&gt;&lt;/td&gt;
EVENT LOG
&lt;td width="85%"&gt;&lt;/td&gt;
System 
&lt;tr&gt;
&lt;/tr&gt;
&lt;td width="15%"&gt;&lt;/td&gt;
EVENT TYPE
&lt;td width="85%" class="red"&gt;&lt;/td&gt;
Error &lt;/p&gt;
&lt;p&gt;
&lt;tr&gt;
&lt;/tr&gt;
&lt;td width="15%"&gt;&lt;/td&gt;
SOURCE
&lt;td width="85%"&gt;&lt;/td&gt;
SBCore 
&lt;tr&gt;
&lt;/tr&gt;
&lt;td width="15%"&gt;&lt;/td&gt;
EVENT ID
&lt;td width="85%"&gt;&lt;/td&gt;
1001 
&lt;tr&gt;
&lt;/tr&gt;
&lt;td width="15%"&gt;&lt;/td&gt;
COMPUTERNAME&amp;nbsp;&amp;nbsp;DOMAIN 
&lt;tr&gt;
&lt;/tr&gt;
&lt;td nowrap="nowrap" width="15%"&gt;&lt;/td&gt;
DATE / TIME&amp;nbsp;&amp;nbsp;
&lt;td width="85%"&gt;&lt;/td&gt;
12/8/2009 12:13:57 AM 
&lt;tr&gt;
&lt;/tr&gt;
&lt;td class="message"&gt;&lt;/td&gt;
MESSAGE
&lt;td&gt;&lt;/td&gt;
The server was shut down because it did not comply with the EULA. For more information, contact Microsoft.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744764" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/bradley/archive/tags/News/default.aspx">News</category></item><item><title>Do your homework before upgrading</title><link>http://msmvps.com/blogs/bradley/archive/2009/12/10/do-your-homework-before-upgrading.aspx</link><pubDate>Fri, 11 Dec 2009 04:09:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744759</guid><dc:creator>bradley</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Ever have one of those moments where you read something and you assumed that something would support something from the get go and it doesn&amp;#39;t?&lt;/p&gt;
&lt;p&gt;Just to prove once again, do your homework before upgrading.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://msexchangeteam.com/archive/2009/12/09/453486.aspx"&gt;&lt;em&gt;http://msexchangeteam.com/archive/2009/12/09/453486.aspx&lt;/em&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size:x-small;"&gt;&lt;em&gt;This is the earliest customers have been able to deploy BlackBerry smartphones with a new Exchange release - ever. Customers who rely on BES as an important part of their messaging and collaboration infrastructure have told us that more rapid support for RIM&amp;#39;s solution is critical to them.&lt;/em&gt; &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size:x-small;"&gt;With all due respect, one doesn&amp;#39;t roll out technology until it does supports the technology that is business critical.&amp;nbsp; Mobile phones these days ARE business critical and thus always make sure you can find solutions/support platforms as you update.&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744759" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/bradley/archive/tags/News/default.aspx">News</category></item><item><title>Security Alerts - December 2009</title><link>http://msmvps.com/blogs/bernard/archive/2009/12/11/security-alerts-december-2009.aspx</link><pubDate>Fri, 11 Dec 2009 03:36:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744754</guid><dc:creator>qbernard</dc:creator><slash:comments>0</slash:comments><description>Recently, Microsoft released the December security bulletin , and one of the critical rated bulletin ( MS09-071 ) is related to IIS (Integrated Windows Authentication). Meant to blog about this earlier but Nazim from IIS team beat me to it :) Been seeing lot of discussions online and patch management related mailing list. So in short, if you are seeing issue on W2k3 IIS 6 after applying the fix via KB973919 , you need to repatch SP2 as described in KB2009746 ....(&lt;a href="http://msmvps.com/blogs/bernard/archive/2009/12/11/security-alerts-december-2009.aspx"&gt;read more&lt;/a&gt;)&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744754" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/bernard/archive/tags/IIS+Downloads/default.aspx">IIS Downloads</category><category domain="http://msmvps.com/blogs/bernard/archive/tags/IIS+Links/default.aspx">IIS Links</category><category domain="http://msmvps.com/blogs/bernard/archive/tags/IIS+KBs/default.aspx">IIS KBs</category><category domain="http://msmvps.com/blogs/bernard/archive/tags/IIS/default.aspx">IIS</category></item><item><title>Desktop virtualization</title><link>http://msmvps.com/blogs/bradley/archive/2009/12/10/desktop-virtualization.aspx</link><pubDate>Fri, 11 Dec 2009 01:14:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744740</guid><dc:creator>bradley</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Server virtualization... desktop virtualization... so are you seeing the new buzzy stuff about desktop virtualization?&lt;/p&gt;
&lt;p&gt;&lt;a href="http://www.forbes.com/forbes/2009/1228/technology-virtualization-vmware-wyse.html"&gt;http://www.forbes.com/forbes/2009/1228/technology-virtualization-vmware-wyse.html&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Now the interesting thing is while the licensing of all of this may be confusing at best and confusing at worst, it is possible for even small businesses to begin to think about virtualized desktops and thin clients and what not.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744740" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/bradley/archive/tags/News/default.aspx">News</category></item><item><title>Brian Harry's comments about my post "No public VS 2010 Beta 3 or release"</title><link>http://msmvps.com/blogs/carlosq/archive/2009/12/10/brian-harry-s-comments-about-my-post-quot-no-public-vs-2010-beta-3-or-release-quot.aspx</link><pubDate>Thu, 10 Dec 2009 23:10:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744732</guid><dc:creator>carlosq</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&lt;a href="http://blogs.msdn.com/bharry/"&gt;Brian Harry&lt;/a&gt;, Microsoft Technical Fellow and Product Unit Manager for Team Foundation Server (TFS) &lt;a href="http://msmvps.com/blogs/carlosq/archive/2009/12/07/no-public-vs-2010-beta-3-or-release-candidate.aspx#comments"&gt;has commented about my last post &amp;quot;No public VS 2010 Beta 3 or release&amp;quot;&lt;/a&gt;. (Brian is making a huge effort in transparency about the performance problems of VS 2010 Beta 2 and the work to get them fixed for RTM)&lt;/p&gt;
&lt;p&gt;I reproduce his comments here:&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;&amp;quot;I don&amp;#39;t know Quan but I can say definitively that this is not an
official Microsoft communication. &amp;nbsp;I&amp;#39;ve remarked before (on my blog)
that when you have an organization of 2,000 - 3,000 people, you have to
assume random stuff happens. &amp;nbsp;Said another way &amp;quot;Don&amp;#39;t believe
everything you read&amp;quot; :)&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;1) We&amp;#39;ve had an RC on the books from the beginning. &amp;nbsp;We are
investigating the possibility of making it a public release. &amp;nbsp;We didn&amp;#39;t
originally for that but the Beta 2 feedback has made us rethink it. &amp;nbsp;We
will ensure that there is time to incorporate customer feedback. Quan
wrote this a while ago and, to be honest, I&amp;#39;m not sure we had reached
that conclusion yet.&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;2) We haven&amp;#39;t decided what we are going to call the public release
yet. &amp;nbsp;We&amp;#39;ve discussed both &amp;quot;Release Candidate&amp;quot; and &amp;quot;Beta 3&amp;quot;. &amp;nbsp;I
responded to one comment on this post: &lt;a href="http://blogs.msdn.com/bharry/archive/2009/12/05/anatomy-of-a-performance-problem.aspx"&gt;http://blogs.msdn.com/bharry/archive/2009/12/05/anatomy-of-a-performance-problem.aspx&lt;/a&gt;
with some thoughts on this. Regardless of what we call it, we will be
looking for customer feedback/validation and will allot time to get it
before releasing.&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;3) March 22 is NOT the release date. It never was. March 22 is the
marketing launch date. We generally don&amp;#39;t announce RTM dates ahead of
time but we do communicate launch dates. &amp;nbsp;Sometimes RTM happens before
the launch, sometimes after. &amp;nbsp;I think it&amp;#39;s fair to say that we are
targeting an RTM in the general timeframe or we wouldn&amp;#39;t have set the
launch date there but there are many considerations that go into launch
dates - lining up with other events, hollidays, venue availability, ...
&amp;nbsp;Further, it would make no sense for us to have set a final RTM date
before getting Beta 2 feedback. &amp;nbsp;We always say &amp;quot;we&amp;#39;ll ship the product
when it&amp;#39;s ready&amp;quot;.&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;Am I the official Microsoft spokesman on this topic, well, um, no.
&amp;nbsp;However, I will say that I&amp;#39;m in all of the discussions about when
we&amp;#39;ll ship, how do we know, what prereleases will we do, etc, etc. &amp;nbsp;And
those who do actually own the &amp;quot;official responsibility&amp;quot; know I&amp;#39;m
writing about it and are keeping quiet. &amp;nbsp;Maintaining plausable
deniability, I think :)&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;If you want to learn more, please visit my blog at &lt;a rel="nofollow" target="_new" href="http://blogs.msdn.com/bharry"&gt;http://blogs.msdn.com/bharry&lt;/a&gt;.
&amp;nbsp;I&amp;#39;m passionate about shipping a great developer tool and partnering
with all of you to accomplish it. &amp;nbsp;I&amp;#39;m always listening and open for
feedback. &amp;nbsp;Nothing I like more than a productive debate.&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;Thanks for listening,&lt;/i&gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&lt;i&gt;Brian&amp;quot;&lt;/i&gt;&lt;/p&gt;
&lt;p&gt;It&amp;#39;s great that Microsoft is considering another public release before RTM. I know it would be to validate the performance fixes after Beta 2, not because add-ins are broken in the current Beta 2. I am fortunate enough to get the private &lt;a href="http://blogs.msdn.com/bharry/archive/2009/12/10/status-update-on-post-beta-2-performance-work.aspx"&gt;Limited CTPs (LCTPs) after Beta 2&lt;/a&gt; but I am under a Non-Disclosure Agreement (NDA) so I can&amp;#39;t blog about their fixes, workarounds or new problems as I did with the public Beta 1 and Beta 2 in the last months to help others, and my new &lt;a href="https://connect.microsoft.com/VisualStudio"&gt;Microsoft Connect&lt;/a&gt; bug reports are now private to Microsoft too. But other developers of add-ins would benefit from that public release, and working add-ins could finally be made available to end users for testing before VS 2010 gets RTM. I wouldn&amp;#39;t have any hope of getting fixes in the automation model between that public release and RTM, though.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744732" width="1" height="1"&gt;</description></item><item><title>Clarification about WCF RIA Services</title><link>http://msmvps.com/blogs/nunogodinho/archive/2009/12/10/clarification-about-wcf-ria-services.aspx</link><pubDate>Thu, 10 Dec 2009 22:33:31 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744722</guid><dc:creator>NunoGodinho</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&amp;#160;&amp;#160; A lot as been said about “.NET RIA Services” now called “WCF RIA Services”, and much more about this name change, since many people doesn’t look at RIA Services like a real WCF Services with all their power, but that isn’t quite true since WCF RIA Services use the same bases as WCF but just make the work a little bit easier for us in terms of the “plumbing/low level development” part. &lt;/p&gt;  &lt;p&gt;&amp;#160;&amp;#160; One of the Product Team members, in this case &lt;a href="http://blogs.msdn.com/saurabh/default.aspx"&gt;Saurabh Pant&lt;/a&gt; in his blog talked about this and why the change, and clarifies the WCF inside WCF RIA Services in this &lt;a target="_blank"&gt;blog post&lt;/a&gt;. He also talks about the motivation of this alignment between the WCF and the RIA Services Team, and in this &lt;a href="http://blogs.msdn.com/endpoint/archive/2009/11/18/the-wcf-services-ecosystem.aspx" target="_blank"&gt;blogs post&lt;/a&gt; the &lt;a href="http://blogs.msdn.com/endpoint/" target="_blank"&gt;.NET Connected Framework Team&lt;/a&gt; explain the entire ecosystem for WCF and in which WCF RIA Services is part of. Check the following picture to know more about this ecosystem that has technologies like:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;WCF Core Services&lt;/li&gt;    &lt;ul&gt;     &lt;li&gt;The most commonly known WCF implementation&lt;/li&gt;   &lt;/ul&gt;    &lt;li&gt;WCF WebHttp/AJAX Services &lt;/li&gt;    &lt;ul&gt;     &lt;li&gt;The RESTful WCF service implementation&lt;/li&gt;   &lt;/ul&gt;    &lt;li&gt;WCF Data Services&lt;/li&gt;    &lt;ul&gt;     &lt;li&gt;The previously known ADO.NET Data Services are now also using WCF for all the communication&lt;/li&gt;   &lt;/ul&gt;    &lt;li&gt;WCF Workflow Services&lt;/li&gt;    &lt;ul&gt;     &lt;li&gt;Workflows that are exposed and interact as WCF Services&lt;/li&gt;   &lt;/ul&gt;    &lt;li&gt;WCF RIA Services&lt;/li&gt;    &lt;ul&gt;     &lt;li&gt;The previously know .NET RIA Services that now use the WCF communication capabilities in order to provide more power to the developer and at the same time, easier development and less “&lt;em&gt;plumbing&lt;/em&gt;”&lt;/li&gt;   &lt;/ul&gt; &lt;/ul&gt;  &lt;p&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/nunogodinho.metablogapi/6064.clip_5F00_image002_5F00_41_5F00_3A218A0E.png" target="_blank"&gt;&lt;img style="border-bottom:0px;border-left:0px;display:block;float:none;margin-left:auto;border-top:0px;margin-right:auto;border-right:0px;" title="clip_image002_4[1]" border="0" alt="clip_image002_4[1]" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/nunogodinho.metablogapi/3324.clip_5F00_image002_5F00_41_5F00_thumb_5F00_37985850.png" width="485" height="365" /&gt;&lt;/a&gt; &lt;/p&gt;  &lt;p&gt;&amp;#160; Hope this helps clarify a little better the WCF part of the WCF RIA Services and their place in the entire WCF ecosystem.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744722" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/Microsoft/default.aspx">Microsoft</category><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/VS2010/default.aspx">VS2010</category><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/.NET+4.0/default.aspx">.NET 4.0</category><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/ADO.NET+Data+Services/default.aspx">ADO.NET Data Services</category><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/RIA+Services/default.aspx">RIA Services</category><category domain="http://msmvps.com/blogs/nunogodinho/archive/tags/WF4/default.aspx">WF4</category></item><item><title>Ressourcen zu DirectAccess</title><link>http://msmvps.com/blogs/rauscher/archive/2009/12/10/ressourcen-zu-directaccess.aspx</link><pubDate>Thu, 10 Dec 2009 21:36:39 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744711</guid><dc:creator>rauscher</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Wie beim Treffen der Forefront User Group heute Abend versprochen, hier die Portalseite bei Microsoft zum Thema DirectAccess:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;&lt;a title="http://technet.microsoft.com/en-us/network/dd420463.aspx" href="http://technet.microsoft.com/en-us/network/dd420463.aspx"&gt;TechNet: Networking and Access Technologies - DirectAccess&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Wir werden versuchen bei einem der nächsten beiden Treffen dazu einen Vortrag zu ermöglichen.&lt;/p&gt;  &lt;p&gt;Viele Grüße    &lt;br /&gt;Dieter     &lt;br /&gt;    &lt;br /&gt;--     &lt;br /&gt;Dieter Rauscher     &lt;br /&gt;MVP Forefront&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744711" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/rauscher/archive/tags/ISA+Server+2006/default.aspx">ISA Server 2006</category><category domain="http://msmvps.com/blogs/rauscher/archive/tags/Forefront+User+Group/default.aspx">Forefront User Group</category><category domain="http://msmvps.com/blogs/rauscher/archive/tags/Windows+Server+2008/default.aspx">Windows Server 2008</category></item><item><title>Render modes</title><link>http://msmvps.com/blogs/arnogerretsen/archive/2009/12/10/render-modes.aspx</link><pubDate>Thu, 10 Dec 2009 21:20:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744710</guid><dc:creator>arno</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Today I have added some more options to ModelConverterX, this time different render modes for the preview. Before you could only render the object as it would show in FS, but now you also have the option to only show the faces (no textures) or to show a wireframe view of the object. I some cases these different render modes might help to figure out what is going on with your model.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/arnogerretsen/0272.rendermodes.jpg"&gt;&lt;img src="http://msmvps.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Blogs.Components.WeblogFiles/arnogerretsen/0272.rendermodes.jpg" border="0" alt="" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;As you might have noticed I am trying to fix some of the open issues with ModelConverterX, so that I can release another stable version. Apart from a few items the list for version 1.1 is empty now, so after that I will focus more on the gPoly tool.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744710" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/arnogerretsen/archive/tags/Tools/default.aspx">Tools</category><category domain="http://msmvps.com/blogs/arnogerretsen/archive/tags/ModelConverterX/default.aspx">ModelConverterX</category></item><item><title>Add a column to an Access Table</title><link>http://msmvps.com/blogs/richardsiddaway/archive/2009/12/10/add-a-column-to-an-access-table.aspx</link><pubDate>Thu, 10 Dec 2009 17:36:44 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744684</guid><dc:creator>RichardSiddaway</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Now we have created our Table we can start adding columns&lt;/p&gt;  &lt;div style="border-bottom:black 1px solid;border-left:black 1px solid;padding-bottom:5px;padding-left:5px;width:750px;padding-right:5px;font-family:consolas,lucida console;font-size:10pt;overflow:auto;border-top:black 1px solid;border-right:black 1px solid;padding-top:5px;"&gt;   &lt;table border="0" cellspacing="0" cellpadding="5"&gt;&lt;tbody&gt;       &lt;tr&gt;         &lt;td valign="top"&gt;           &lt;div style="padding-bottom:5px;padding-left:5px;padding-right:5px;font-family:consolas,lucida console;background:#cecece;font-size:10pt;padding-top:5px;"&gt;001              &lt;br /&gt;002               &lt;br /&gt;003               &lt;br /&gt;004               &lt;br /&gt;005               &lt;br /&gt;006               &lt;br /&gt;007               &lt;br /&gt;008               &lt;br /&gt;009               &lt;br /&gt;010               &lt;br /&gt;011               &lt;br /&gt;012               &lt;br /&gt;013               &lt;br /&gt;014               &lt;br /&gt;015               &lt;br /&gt;016               &lt;br /&gt;017               &lt;br /&gt;018               &lt;br /&gt;019               &lt;br /&gt;020               &lt;br /&gt;021               &lt;br /&gt;022               &lt;br /&gt;023               &lt;br /&gt;024               &lt;br /&gt;025               &lt;br /&gt;026               &lt;br /&gt;027               &lt;br /&gt;028               &lt;br /&gt;029               &lt;br /&gt;030               &lt;br /&gt;031               &lt;br /&gt;032               &lt;br /&gt;033               &lt;br /&gt;034               &lt;br /&gt;035               &lt;br /&gt;036               &lt;br /&gt;037               &lt;br /&gt;038               &lt;br /&gt;039               &lt;br /&gt;040               &lt;br /&gt;041               &lt;br /&gt;042               &lt;br /&gt;043               &lt;br /&gt;044               &lt;br /&gt;045               &lt;br /&gt;046               &lt;br /&gt;047               &lt;br /&gt;048               &lt;br /&gt;049               &lt;br /&gt;050               &lt;br /&gt;051               &lt;br /&gt;052               &lt;br /&gt;053               &lt;br /&gt;054               &lt;br /&gt;055               &lt;br /&gt;056               &lt;br /&gt;057               &lt;br /&gt;058               &lt;br /&gt;059               &lt;br /&gt;060               &lt;br /&gt;061               &lt;br /&gt;062               &lt;br /&gt;063               &lt;br /&gt;064               &lt;br /&gt;065               &lt;br /&gt;066               &lt;br /&gt;067               &lt;br /&gt;068               &lt;br /&gt;069               &lt;br /&gt;070               &lt;br /&gt;071               &lt;br /&gt;072               &lt;br /&gt;073               &lt;br /&gt;074               &lt;br /&gt;075               &lt;br /&gt;076               &lt;br /&gt;077               &lt;br /&gt;078               &lt;br /&gt;079               &lt;br /&gt;080               &lt;br /&gt;081               &lt;br /&gt;082               &lt;br /&gt;083               &lt;br /&gt;084               &lt;br /&gt;085               &lt;br /&gt;086               &lt;br /&gt;&lt;/div&gt;         &lt;/td&gt;          &lt;td valign="top" nowrap="nowrap"&gt;           &lt;div style="padding-bottom:5px;padding-left:5px;padding-right:5px;font-family:consolas,lucida console;background:#fcfcfc;font-size:10pt;padding-top:5px;"&gt;&lt;span style="color:#00008b;"&gt;function&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;CmdletBinding&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#00008b;"&gt;param&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[System.Data.OleDb.OleDbConnection]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$connection&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[switch]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$notnull&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;datetime&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$dtname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;unique&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$uniquename&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;binary&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$binname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;bit&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$bitname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;tinyinteger&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$tnyintname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;smallinteger&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$smlintname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;integer&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$intname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;double&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$dblname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;real&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$realname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;float&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$floatname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;decimal&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$decname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;money&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$mnyname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;char&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$charname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;text&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$textname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;image&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$imgname&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;char&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;[&lt;/span&gt;&lt;span style="color:#add8e6;"&gt;parameter&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;text&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;]&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[int]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$size&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#800080;"&gt;10&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#00008b;"&gt;switch&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$psCmdlet&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;.&lt;/span&gt;&lt;span style="color:#000000;"&gt;ParameterSetName&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;datetime&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $dtname DATETIME&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;binary&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $binname BINARY&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;bit&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $bitname BIT&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;unique&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $uniquename UNIQUEIDENTIFIER&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;tinyinteger&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $tnyintname TINYINT&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;smallinteger&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $smlintname SMALLINT&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;integer&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $intname INTEGER&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;double&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $dblname DOUBLE&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;float&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $floatname FLOAT&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;real&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $realname REAL&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;decimal&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $decname DECIMAL&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;money&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $mnyname MONEY&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;char&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $charname CHARACTER($size)&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;text&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $textname TEXT($size)&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;image&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;ALTER TABLE $table ADD COLUMN $imgname IMAGE&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#00008b;"&gt;if&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$notnull&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;+&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot; NOT NULL&amp;quot;&lt;/span&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;              &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#0000ff;"&gt;Write-Debug&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$cmd&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#0000ff;"&gt;New-Object&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;System.Data.OleDb.OleDbCommand&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$cmd&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;.&lt;/span&gt;&lt;span style="color:#000000;"&gt;ExecuteNonQuery&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt; &lt;/div&gt;         &lt;/td&gt;       &lt;/tr&gt;     &lt;/tbody&gt;&lt;/table&gt; &lt;/div&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;The first set of parameters define the connection and table name. The $notnull parameter adds the NOT NULL statement to the SQL we create. This forces us to add a value for the column when we insert a row. These parameters are not part of a parameter set – this means they work with all parameter sets.&lt;/p&gt;  &lt;p&gt;Parameter sets are used in this function to make the data types mutually exclusive – i.e. one call to Add-AccessColumn can add one column of one, and only one, data type. The size parameter applies to character and text data types so is a member of both parameter sets.&lt;/p&gt;  &lt;p&gt;The parameter set is used in a switch statement to create the SQL to add a column of the correct type. If the $notnull switch is set we add the appropriate commands to the SQL.&lt;/p&gt;  &lt;p&gt;With advanced functions in PowerShell v2 we get the ability to use the common parameters so I can use&lt;/p&gt;  &lt;p&gt;New-AccessColumn -connection $db -table $table -dtname Mydate2 –notnull&amp;#160; -Debug&lt;/p&gt;  &lt;p&gt;and the Write-Debug statements will be triggered. In this case I get a dump of the SQL I have created. The function finishes by executing the SQL against the database as we have seen before.&lt;/p&gt;  &lt;p&gt;As an example of using the function&lt;/p&gt;  &lt;div style="border-bottom:black 1px solid;border-left:black 1px solid;padding-bottom:5px;padding-left:5px;width:750px;padding-right:5px;font-family:consolas,lucida console;font-size:10pt;overflow:auto;border-top:black 1px solid;border-right:black 1px solid;padding-top:5px;"&gt;   &lt;table border="0" cellspacing="0" cellpadding="5"&gt;&lt;tbody&gt;       &lt;tr&gt;         &lt;td valign="top"&gt;           &lt;div style="padding-bottom:5px;padding-left:5px;padding-right:5px;font-family:consolas,lucida console;background:#cecece;font-size:10pt;padding-top:5px;"&gt;001              &lt;br /&gt;002               &lt;br /&gt;003               &lt;br /&gt;004               &lt;br /&gt;005               &lt;br /&gt;006               &lt;br /&gt;007               &lt;br /&gt;008               &lt;br /&gt;009               &lt;br /&gt;010               &lt;br /&gt;011               &lt;br /&gt;012               &lt;br /&gt;013               &lt;br /&gt;014               &lt;br /&gt;015               &lt;br /&gt;016               &lt;br /&gt;017               &lt;br /&gt;018               &lt;br /&gt;019               &lt;br /&gt;020               &lt;br /&gt;021               &lt;br /&gt;022               &lt;br /&gt;023               &lt;br /&gt;024               &lt;br /&gt;025               &lt;br /&gt;026               &lt;br /&gt;027               &lt;br /&gt;028               &lt;br /&gt;029               &lt;br /&gt;030               &lt;br /&gt;031               &lt;br /&gt;032               &lt;br /&gt;033               &lt;br /&gt;034               &lt;br /&gt;035               &lt;br /&gt;036               &lt;br /&gt;037               &lt;br /&gt;038               &lt;br /&gt;039               &lt;br /&gt;040               &lt;br /&gt;041               &lt;br /&gt;042               &lt;br /&gt;043               &lt;br /&gt;044               &lt;br /&gt;045               &lt;br /&gt;046               &lt;br /&gt;047               &lt;br /&gt;048               &lt;br /&gt;049               &lt;br /&gt;&lt;/div&gt;         &lt;/td&gt;          &lt;td valign="top" nowrap="nowrap"&gt;           &lt;div style="padding-bottom:5px;padding-left:5px;padding-right:5px;font-family:consolas,lucida console;background:#fcfcfc;font-size:10pt;padding-top:5px;"&gt;&lt;span style="color:#0000ff;"&gt;Import-Module&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;accessfunctions&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-Force&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#0000ff;"&gt;Open-AccessDatabase&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-name&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;test03.mdb&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-path&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;c:\test&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot;NewTable2&amp;quot;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessTable&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-dtname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;Mydate&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-dtname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;Mydate2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-uniquename&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyUnique&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-uniquename&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyUnique2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-binname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyBinary&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-bitname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyBit&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-binname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyBinary2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-bitname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyBit2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-tnyintname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyTiny&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-smlintname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MySmall&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-intname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyInt&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-tnyintname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyTiny2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-smlintname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MySmall2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-intname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyInt2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-dblname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyDouble&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-realname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyReal&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-floatname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyFloat&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-decname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyDecimal&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-mnyname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyMoney&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-dblname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyDouble2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-realname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyReal2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-floatname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyFloat2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-decname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyDecimal2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-mnyname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyMoney2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-charname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyChar&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-charname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyChar2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-size&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#800080;"&gt;20&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-charname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyChar3&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-size&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#800080;"&gt;20&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-textname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyText&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-textname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyText2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-size&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#800080;"&gt;20&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-textname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyText3&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-size&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#800080;"&gt;20&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-imgname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyImg&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;New-AccessColumn&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000080;"&gt;-imgname&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;MyImg2&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160; &lt;/span&gt;&lt;span style="color:#000080;"&gt;-notnull&lt;/span&gt;               &lt;br /&gt;              &lt;br /&gt;&lt;span style="color:#0000ff;"&gt;Close-AccessDatabase&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$db&lt;/span&gt; &lt;/div&gt;         &lt;/td&gt;       &lt;/tr&gt;     &lt;/tbody&gt;&lt;/table&gt; &lt;/div&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;Producing this becomes easy when using cut and paste within an editor.&lt;/p&gt;  &lt;p&gt;Next we will look at removing columns and tables&lt;/p&gt;  &lt;div style="padding-bottom:0px;margin:0px;padding-left:0px;padding-right:0px;display:inline;float:none;padding-top:0px;" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:f26a8e78-4bef-44f5-8d50-62dc951c24a7" class="wlWriterEditableSmartContent"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/PowerShell" rel="tag"&gt;PowerShell&lt;/a&gt;,&lt;a href="http://technorati.com/tags/Office+2010" rel="tag"&gt;Office 2010&lt;/a&gt;,&lt;a href="http://technorati.com/tags/Access" rel="tag"&gt;Access&lt;/a&gt;,&lt;a href="http://technorati.com/tags/Add+column" rel="tag"&gt;Add column&lt;/a&gt;&lt;/div&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744684" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/Powershell/default.aspx">Powershell</category><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/PowerShell+V2/default.aspx">PowerShell V2</category><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/Office+2010/default.aspx">Office 2010</category><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/Access/default.aspx">Access</category></item><item><title>C’est Noël avec Microsoft® Word 2007 et Avery®</title><link>http://msmvps.com/blogs/vista/archive/2009/12/10/c-est-no-235-l-avec-microsoft-174-word-2007-et-avery-174.aspx</link><pubDate>Thu, 10 Dec 2009 17:16:22 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744681</guid><dc:creator>Patrice BONNEFOY</dc:creator><slash:comments>0</slash:comments><description>Salut à tous, Dans sa dernière lettre d’actualités “Office”, Microsoft®, par la voix de Jean-Christophe PITIÉ, Directeur produits Office system, nous fait part d’une information intéressante sur les produits AVERY . Pour préparer dès maintenant vos cartes de Noël et étiquettes cadeaux avec les produits Avery®, vous pouvez télécharger l&amp;#39;assistant ou sa mise à jour pour Microsoft® Word téléchargeable gratuitement. Et si rester au fait de l’actualité informatique Microsoft® est vous primordial,...(&lt;a href="http://msmvps.com/blogs/vista/archive/2009/12/10/c-est-no-235-l-avec-microsoft-174-word-2007-et-avery-174.aspx"&gt;read more&lt;/a&gt;)&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744681" width="1" height="1"&gt;</description></item><item><title>New Access Table</title><link>http://msmvps.com/blogs/richardsiddaway/archive/2009/12/10/new-access-table.aspx</link><pubDate>Thu, 10 Dec 2009 17:10:51 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744679</guid><dc:creator>RichardSiddaway</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;I have already presented a function to create a new access table but I wasn’t very happy with it because we had to supply the full table creation SQL script.&lt;/p&gt;  &lt;p&gt;I have altered that function so it creates an empty table. We can then use the Add-AccessColumn function to add columns. This also means I have a function to add columns to a table as and when I need them.&lt;/p&gt;  &lt;p&gt;The function to create a table becomes&lt;/p&gt;  &lt;div style="border-bottom:black 1px solid;border-left:black 1px solid;padding-bottom:5px;padding-left:5px;width:750px;padding-right:5px;font-family:consolas,lucida console;font-size:10pt;overflow:auto;border-top:black 1px solid;border-right:black 1px solid;padding-top:5px;"&gt;   &lt;table border="0" cellspacing="0" cellpadding="5"&gt;&lt;tbody&gt;       &lt;tr&gt;         &lt;td valign="top"&gt;           &lt;div style="padding-bottom:5px;padding-left:5px;padding-right:5px;font-family:consolas,lucida console;background:#cecece;font-size:10pt;padding-top:5px;"&gt;001              &lt;br /&gt;002               &lt;br /&gt;003               &lt;br /&gt;004               &lt;br /&gt;005               &lt;br /&gt;006               &lt;br /&gt;007               &lt;br /&gt;008               &lt;br /&gt;009               &lt;br /&gt;010               &lt;br /&gt;&lt;/div&gt;         &lt;/td&gt;          &lt;td valign="top" nowrap="nowrap"&gt;           &lt;div style="padding-bottom:5px;padding-left:5px;padding-right:5px;font-family:consolas,lucida console;background:#fcfcfc;font-size:10pt;padding-top:5px;"&gt;&lt;span style="color:#00008b;"&gt;function&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;New-AccessTable&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;{&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#006400;"&gt;## assumes database is open&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#00008b;"&gt;param&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[string]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$table&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#008080;"&gt;[System.Data.OleDb.OleDbConnection]&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$connection&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8b0000;"&gt;&amp;quot; CREATE TABLE $table&amp;quot;&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$cmd&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;=&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#0000ff;"&gt;New-Object&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#8a2be2;"&gt;System.Data.OleDb.OleDbCommand&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$sql&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;,&lt;/span&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$connection&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;span style="color:#ff4500;"&gt;$cmd&lt;/span&gt;&lt;span style="color:#a9a9a9;"&gt;.&lt;/span&gt;&lt;span style="color:#000000;"&gt;ExecuteNonQuery&lt;/span&gt;&lt;span style="color:#000000;"&gt;(&lt;/span&gt;&lt;span style="color:#000000;"&gt;)&lt;/span&gt;               &lt;br /&gt;&lt;span style="color:#000000;"&gt;}&lt;/span&gt; &lt;/div&gt;         &lt;/td&gt;       &lt;/tr&gt;     &lt;/tbody&gt;&lt;/table&gt; &lt;/div&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;Our parameters become the connection and a table name.&amp;#160; I don’t check that the table name exists – that will be a future refinement. We then issue a simple CREATE TABLE command.&lt;/p&gt;  &lt;div style="padding-bottom:0px;margin:0px;padding-left:0px;padding-right:0px;display:inline;float:none;padding-top:0px;" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:bb4ad314-a610-4282-8986-beadff852436" class="wlWriterEditableSmartContent"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/PowerShell" rel="tag"&gt;PowerShell&lt;/a&gt;,&lt;a href="http://technorati.com/tags/Office+2010" rel="tag"&gt;Office 2010&lt;/a&gt;,&lt;a href="http://technorati.com/tags/Access" rel="tag"&gt;Access&lt;/a&gt;,&lt;a href="http://technorati.com/tags/Create+Table" rel="tag"&gt;Create Table&lt;/a&gt;&lt;/div&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744679" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/Powershell/default.aspx">Powershell</category><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/PowerShell+V2/default.aspx">PowerShell V2</category><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/Office+2010/default.aspx">Office 2010</category><category domain="http://msmvps.com/blogs/richardsiddaway/archive/tags/Access/default.aspx">Access</category></item><item><title>Facebook - New privacy announcements</title><link>http://msmvps.com/blogs/harrywaldron/archive/2009/12/10/facebook-new-privacy-announcements.aspx</link><pubDate>Thu, 10 Dec 2009 15:50:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744665</guid><dc:creator>Harry Waldron</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&lt;img src="http://msmvps.com/emoticons/emotion-55.gif" alt="Idea" /&gt; Facebook has announced the folling privacy and security improvements:&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Facebook - New privacy announcements&lt;/strong&gt;&lt;br /&gt;&lt;a href="http://isc.sans.org/diary.html?storyid=7726"&gt;http://isc.sans.org/diary.html?storyid=7726&lt;/a&gt;&lt;br /&gt;&lt;a href="http://www.facebook.com/press/releases.php?p=133917"&gt;http://www.facebook.com/press/releases.php?p=133917&lt;/a&gt;&lt;br /&gt;&lt;a href="http://blog.facebook.com/blog.php?post=196629387130"&gt;http://blog.facebook.com/blog.php?post=196629387130&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Message from the founder Mark Zuckerberg&lt;/strong&gt;&lt;br /&gt;&lt;a href="http://blog.facebook.com/blog.php?post=190423927130"&gt;http://blog.facebook.com/blog.php?post=190423927130&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;QUOTE:&lt;/strong&gt; Setting a new standard in user control, Facebook announced today that it is &lt;strong&gt;calling on its more than 350 million users to review and update their privacy settings&lt;/strong&gt;&amp;mdash;a first among major Internet services. In addition, Facebook will be rolling out &lt;strong&gt;easy-to-use tools to empower people to personalize control over their information&lt;/strong&gt;&amp;mdash;based on what the content is, why they are sharing it, when, and the audience they seek to reach.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;* Adding Control For Each Item&lt;br /&gt;* Simplified Privacy Settings&lt;br /&gt;* Help In Choosing Settings&lt;br /&gt;* Expanded Privacy Education&lt;/strong&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744665" width="1" height="1"&gt;</description></item><item><title>Microsoft Virtual Business Cards para MCPs</title><link>http://msmvps.com/blogs/lfranco/archive/2009/12/10/microsoft-virtual-business-cards-para-mcps.aspx</link><pubDate>Thu, 10 Dec 2009 13:11:06 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744641</guid><dc:creator>lfranco</dc:creator><slash:comments>0</slash:comments><description>&lt;p align="justify"&gt;Como ya sabéis, el pasado Junio Microsoft decidió terminar con los paquetes de bienvenida (también llamados Welcome kits). Se supone que los motivos son ecológicos y no tienen nada que ver con el ahorro de costes, pero en estos tiempos de crisis... uhm... no se, no se :-)&lt;/p&gt;  &lt;p align="justify"&gt;La cuestión es que existe un nuevo servicio para todos los MCP gracias al cual uno se puede crear su propia tarjeta de visita, y compartirla con el resto de la comunidad. &lt;/p&gt;  &lt;p align="justify"&gt;Al igual que &lt;a href="http://geeks.ms/blogs/dnudelman/archive/2009/12/09/virtual-business-cards-released.aspx" target="_blank"&gt;David&lt;/a&gt;, al principio pensé que era una chorrada, pero la verdad es que el resultado es una chulada :-)&lt;/p&gt;  &lt;p align="justify"&gt;Os dejo una muestra en diversos formatos:&lt;/p&gt;  &lt;p align="justify"&gt;&amp;#160;&lt;/p&gt;  &lt;p align="justify"&gt;&lt;strong&gt;&lt;u&gt;HTML:&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt; &lt;iframe height="180" src="https://www.mcpvirtualbusinesscard.com/VBCServer/lfranco/card" frameborder="0" width="397" scrolling="no"&gt;&lt;/iframe&gt;  &lt;p align="justify"&gt;&amp;#160;&lt;/p&gt;  &lt;p align="justify"&gt;&lt;strong&gt;&lt;u&gt;Java Script (mira en My Certifications):&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;  &lt;p&gt;&lt;iframe height="177" src="https://www.mcpvirtualbusinesscard.com/VBCServer/lfranco/interactivecard" frameborder="0" width="392" scrolling="no"&gt;&lt;/iframe&gt;&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;&lt;strong&gt;&lt;u&gt;Imagen:&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;  &lt;p&gt;&lt;a href="http://www.uyssoft.com/blog/images/MicrosoftVirtualBusinessCards_B70E/GetCardImage.png"&gt;&lt;img style="border-bottom:0px;border-left:0px;display:inline;border-top:0px;border-right:0px;" title="GetCardImage" border="0" alt="GetCardImage" src="http://www.uyssoft.com/blog/images/MicrosoftVirtualBusinessCards_B70E/GetCardImage_thumb.png" width="401" height="181" /&gt;&lt;/a&gt; &lt;/p&gt;  &lt;p&gt;Saludos,&lt;/p&gt;
** crossposting desde el blog de Lluís Franco en geeks.ms **&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744641" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/lfranco/archive/tags/Frikadas/default.aspx">Frikadas</category><category domain="http://msmvps.com/blogs/lfranco/archive/tags/MCP/default.aspx">MCP</category></item><item><title>BlackBerry Enterprise Server (BES) and Microsoft Exchange Server 2010</title><link>http://msmvps.com/blogs/wssra/archive/2009/12/10/blackberry-enterprise-server-bes-and-microsoft-exchange-server-2010.aspx</link><pubDate>Thu, 10 Dec 2009 11:45:17 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744639</guid><dc:creator>Thomas K.H. Bittner</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;Microsoft recognized that many customers rely on BlackBerry Servers. This is why they collaborated already closely with RIM to add BlackBerry Support to Exchange Server 2010.&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;BlackBerry Enterprise Server (BES) is now fully supported on Microsoft Exchange Server 2010 and BlackBerry Technical Support Services are readily available.&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;In order to enable full support, this updates are required:      &lt;br /&gt;&lt;/font&gt;&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=371add31-d7a0-4c8b-8325-a6fced2d05e6&amp;amp;displaylang=en" target="_blank"&gt;Roll-Up 1 (RU1) for Exchange Server 2010&lt;/a&gt;&lt;/font&gt; &lt;/li&gt;    &lt;li&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;a href="http://www.microsoft.com/downloads/details.aspx?familyid=e17e7f31-079a-43a9-bff2-0a110307611e&amp;amp;displaylang=en" target="_blank"&gt;MAPI v6.5.8147&lt;/a&gt;&lt;/font&gt; &lt;/li&gt;    &lt;li&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;a title="BlackBerry Enterprise Server 5.0.1 Maintenance Release 1 (MR1)" href="http://www.blackberry.com/support/downloads" target="_blank"&gt;BlackBerry Enterprise Server 5.0.1 Maintenance Release 1 (MR1)&lt;/a&gt;&lt;/font&gt; &lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;All three of these updates are available to customers of Exchange Server 2010 and BlackBerry Enterprise Server v.5.0 with Service Pack 1 at no cost. BlackBerry Enterprise Server v5.0 Service Pack 1 and Maintenance Release 1 can be found here: &lt;/font&gt;&lt;a href="http://www.blackberry.com/support/downloads" target="_blank"&gt;http://www.blackberry.com/support/downloads&lt;/a&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;Additional information on the solution requirements, preparing the BlackBerry environment for Microsoft Exchange Server2010, can be found on the BlackBerry site &lt;a href="http://na.blackberry.com/eng/services/server/exchange/2010support.jsp" target="_blank"&gt;here&lt;/a&gt;&lt;/font&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;/font&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;.&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;Exchange Server 2010 Roll-up 1 also includes other minor updates to areas including calendaring, OWA, and transport. You can read more about Exchange Server 2010 RU1 &lt;a href="http://support.microsoft.com/kb/976573" target="_blank"&gt;here&lt;/a&gt;&lt;/font&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;/font&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;.&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&amp;#160;&lt;/font&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744639" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/wssra/archive/tags/Exchange/default.aspx">Exchange</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/BlackBerry/default.aspx">BlackBerry</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/Mobile/default.aspx">Mobile</category></item><item><title>Exchange, SharePoint and SQL on Hyper-V and NetApp</title><link>http://msmvps.com/blogs/wssra/archive/2009/12/10/exchange-sharepoint-and-sql-on-hyper-v-and-netapp.aspx</link><pubDate>Thu, 10 Dec 2009 11:07:31 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744634</guid><dc:creator>Thomas K.H. Bittner</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;A Technical Report has been released, which is a detailed Solution Guide for Microsoft Exchange, SQL, SharePoint Server mixed workload running within the Virtual Machines hosted on Microsoft Hypervisor (Hyper-V) and the NetApp MetroCluster environment.&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;The architectural solution details provided in this Technical Report is extremely helpful to customers which showcases the simplicity of a robust infrastructure with Windows Hyper-V 2008 R2 in a virtual environment with NetApp storage. It provides the ability to maintain High Availability for both the computing and storage resources between the Primary and Secondary sites and a complete Disaster Recovery in the event of the loss of a complete site. This infrastructure also offers the ability to dynamically move an environment’s complete operation between the Primary and Secondary sites to minimize disruption during scheduled maintenance events.&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;The report also focuses on various failure scenarios and the value of deploying Windows Server 2008 R2, Hyper-V Live Migration, and NetApp MetroCluster to recover from these failures. Each failure scenario simulates real-world operational failures and real disasters. The expected outcome and actual results are described in terms of NetApp MetroCluster product operation and the resulting behavior of Hyper-V servers and virtual machines (VMs).&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&lt;a href="http://www.netapp.com/us/library/technical-reports/tr-3804.html" target="_blank"&gt;Read Technical Report here&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;  &lt;p&gt;&lt;font color="#000080" size="2" face="Verdana"&gt;&amp;#160;&lt;/font&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744634" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/wssra/archive/tags/SQL/default.aspx">SQL</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/Storage/default.aspx">Storage</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/Exchange/default.aspx">Exchange</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/Cluster/default.aspx">Cluster</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/Hyper-V/default.aspx">Hyper-V</category><category domain="http://msmvps.com/blogs/wssra/archive/tags/SharePoint/default.aspx">SharePoint</category></item><item><title>ALT.NET Hispano VAN (reunión virtual): Aplicaciones modulares con Prism</title><link>http://msmvps.com/blogs/lopez/archive/2009/12/10/alt-net-hispano-van-reuni-243-n-virtual-aplicaciones-modulares-con-prism.aspx</link><pubDate>Thu, 10 Dec 2009 10:49:14 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744625</guid><dc:creator>lopez</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Este sábado 12 de diciembre, 19 GMT (4 de la tarde aquí en Buenos Aires) de nuevo tenemos VAN (Reunión virtual, des-conferencia) organizada por &lt;a href="http://altnet-hispano.pbworks.com/" target="_blank"&gt;la comunidad de ALT.NET Hispano&lt;/a&gt;.&lt;/p&gt;  &lt;p&gt;(Más información sobre cómo asistir a la reunión virtual, software necesario, enlaces:&lt;/p&gt;  &lt;p&gt;&lt;a title="http://altnet-hispano.pbworks.com/Descripcion-de-Reuniones" href="http://altnet-hispano.pbworks.com/Descripcion-de-Reuniones"&gt;http://altnet-hispano.pbworks.com/Descripcion-de-Reuniones&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;)&lt;/p&gt;  &lt;p&gt;Esta vez el tema será Prism (&lt;a href="http://www.codeplex.com/CompositeWPF/" target="_blank"&gt;Composite Application Guidance para Windows Presentation Foundation y Silverlight&lt;/a&gt;). La introducción estará a cargo del bueno de &lt;a href="http://twitter.com/juliandominguez" target="_blank"&gt;@juliandominguez&lt;/a&gt;, que nos comenta &lt;a href="http://groups.google.com/group/altnet-hispano/browse_thread/thread/57e0df07accb3792?hl=es" target="_blank"&gt;en la lista de ALT.NET Hispano&lt;/a&gt;:&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;La idea de este próximo sábado es presentar sobre Prism (o Composite Application Guidance for WPF and Silverlight para los que prefieren el nombre real pero aburrido).&lt;/p&gt;    &lt;p&gt;¿Qué es Prism de patterns &amp;amp; practices y qué desafíos resuelve?&lt;/p&gt;    &lt;p&gt;¿Qué beneficios les brinda a arquitectos, desarrolladores y a la interacción con diseñadores?&lt;/p&gt;    &lt;p&gt;En esta sesión mostraré cómo Prism nos ayuda a trabajar en equipos distribuidos, no distribuidos, grandes o pequeños, con requerimientos cambiantes, aplicando conceptos como TDD y patrones de UI como Model View ViewModel (MVVM). También voy a mostrar cómo nos ayuda a reusar código que funcione en WPF y en Silverlight.&lt;/p&gt;    &lt;p&gt;Vamos a estar viendo los beneficios que nos trae Prism a la hora de construir una aplicación compuesta, como así también en qué (lio?) nos metemos cuando queremos usar Prism en una aplicación que no lo amerita.&lt;/p&gt;    &lt;p&gt;Espero que les resulte muy interesante a quienes no conocen Prism y tienen pensado empezar un proyecto en WPF o Silverlight.&lt;/p&gt;    &lt;p&gt;Sé que normalmente las VAN suelen ser a las 18:00 GMT, pero debido a mi horario (actualmente estoy en Redmond), preferiría que sea las 19:00 GMT. Esto sería el sábado 12/12.&lt;/p&gt;    &lt;p&gt;Así que la reunión será este sábado a las 19GMT (no a las 18GMT como otras veces).&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;Mi colección de enlaces sobre Prism:&lt;/p&gt;  &lt;p&gt;&lt;a href="http://delicious.com/ajlopez/prism"&gt;http://delicious.com/ajlopez/prism&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;Otros interesantes:&lt;/p&gt;  &lt;p&gt;&lt;a href="http://delicious.com/ajlopez/mef"&gt;http://delicious.com/ajlopez/mef&lt;/a&gt;    &lt;br /&gt;&lt;a href="http://delicious.com/ajlopez/mvvm"&gt;http://delicious.com/ajlopez/mvvm&lt;/a&gt;    &lt;br /&gt;&lt;a href="http://delicious.com/ajlopez/silverlight"&gt;http://delicious.com/ajlopez/silverlight&lt;/a&gt;    &lt;br /&gt;&lt;a href="http://delicious.com/ajlopez/wpf"&gt;http://delicious.com/ajlopez/wpf&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;(especialmente si agregan examples o tutorial, como &lt;a href="http://delicious.com/ajlopez/mef+example"&gt;http://delicious.com/ajlopez/mef+example&lt;/a&gt;)&lt;/p&gt;  &lt;p&gt;Si es la primera vez que topan con el término VAN, les recuerdo:&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;Si no conocen qué es una reunión VAN, pueden consultar &lt;a href="http://www.zachariahyoung.com/zy/post/2009/01/Introduction-to-Virtual-ALTNET.aspx"&gt;VAN meetings&lt;/a&gt;. Para ver cómo se desarrolla una VAN de ALT.NET Hispano, y qué software necesitan para asistir, ver &lt;a href="http://altnet-hispano.pbworks.com/Descripcion-de-Reuniones" target="_blank"&gt;Descripcion-de-Reuniones-VAN&lt;/a&gt;. Pueden ver &lt;a href="http://altnet-hispano.pbworks.com/Historial-de-reuniones"&gt;el historial de anteriores reuniones VAN&lt;/a&gt; (visiten las que dieron, por ejemplo, sobre NHibernate, WPF y demás) (yo participé en &lt;a href="http://msmvps.com/blogs/lopez/archive/2009/09/18/resultado-de-la-van-en-alt-net-hispano-sobre-scrum.aspx"&gt;VAN sobre Scrum&lt;/a&gt; y en otra &lt;a href="http://msmvps.com/blogs/lopez/archive/2009/10/27/resultado-de-la-van-alt-net-hispano-sobre-generaci-243-n-de-c-243-digo.aspx"&gt;sobre generación de código&lt;/a&gt;). También pueden suscribirse para proponer nuevos temas, y colaborar con la comunidad. Si no pueden asistir a ésta VAN, seguramente quedará publicada más adelante, con video incluido.&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;Nos leemos!&lt;/p&gt;  &lt;p&gt;Angel “Java” Lopez    &lt;br /&gt;&lt;a href="http://www.ajlopez.com"&gt;http://www.ajlopez.com&lt;/a&gt;    &lt;br /&gt;&lt;a href="http://twitter.com/ajlopez"&gt;http://twitter.com/ajlopez&lt;/a&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744625" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/lopez/archive/tags/.NET/default.aspx">.NET</category><category domain="http://msmvps.com/blogs/lopez/archive/tags/Windows+Presentation+Foundation/default.aspx">Windows Presentation Foundation</category><category domain="http://msmvps.com/blogs/lopez/archive/tags/Desarrollo+de+Software/default.aspx">Desarrollo de Software</category><category domain="http://msmvps.com/blogs/lopez/archive/tags/Silverlight/default.aspx">Silverlight</category></item><item><title>Descargar archivos desde un FTP en .NET - How to Download files from FTP using .NET</title><link>http://msmvps.com/blogs/peplluis/archive/2009/12/10/descargar-archivos-desde-un-ftp-en-net-how-to-download-files-from-ftp-using-net.aspx</link><pubDate>Thu, 10 Dec 2009 10:45:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744628</guid><dc:creator>peplluis</dc:creator><slash:comments>0</slash:comments><description>&lt;h2 class="pageTitle"&gt;&lt;img height="300" width="488" src="http://msmvps.com/cfs-filesystemfile.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/peplluis.Projectes/4807.FtpClient.jpg" alt="FtpClient" border="0" style="max-width:550px;border:1px solid black;" /&gt;&lt;/h2&gt;
&lt;table cellpadding="0" cellspacing="0" border="0" class="MsoTableGrid" style="BORDER-COLLAPSE:collapse;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-yfti-tbllook:1184;mso-border-insideh:none;mso-border-insidev:none;"&gt;
&lt;tbody&gt;
&lt;tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;"&gt;
&lt;td width="354" valign="top" style="padding-bottom:0cm;background-color:transparent;padding-left:5.4pt;width:265.15pt;padding-right:5.4pt;padding-top:0cm;border-color:#f0f0f0;"&gt;
&lt;p class="MsoNormal" align="center"&gt;&lt;span style="FONT-FAMILY:Calibri;FONT-SIZE:small;"&gt;&lt;img height="23" width="35" src="http://msmvps.com/cfs-filesystemfile.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/peplluis.Projectes/flags_5F00_Sp.jpg" style="BORDER-BOTTOM:black 1px solid;BORDER-LEFT:black 1px solid;BORDER-TOP:black 1px solid;BORDER-RIGHT:black 1px solid;" alt="" /&gt;&lt;span style="font-size:x-small;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td width="354" valign="top" style="padding-bottom:0cm;background-color:transparent;padding-left:5.4pt;width:265.15pt;padding-right:5.4pt;padding-top:0cm;border-color:#f0f0f0;"&gt;
&lt;p class="MsoNormal" align="center"&gt;&lt;span lang="EN-US" style="mso-ansi-language:EN-US;"&gt;&lt;span style="FONT-SIZE:small;"&gt;&lt;span style="FONT-FAMILY:Calibri;"&gt;&lt;span style="font-size:x-small;"&gt;&lt;img height="19" width="35" src="http://msmvps.com/cfs-filesystemfile.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/peplluis.Projectes/flag_5F00_UsaUk.jpg" style="BORDER-BOTTOM:black 1px solid;BORDER-LEFT:black 1px solid;BORDER-TOP:black 1px solid;BORDER-RIGHT:black 1px solid;" alt="" /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr style="mso-yfti-irow:1;"&gt;
&lt;td width="354" valign="top" style="padding-bottom:0cm;background-color:transparent;padding-left:5.4pt;width:265.15pt;padding-right:5.4pt;padding-top:0cm;border-color:#f0f0f0;"&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="LINE-HEIGHT:115%;COLOR:black;FONT-SIZE:12pt;mso-ascii-font-family:Calibri;mso-hansi-font-family:Calibri;mso-fareast-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-language:ES;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;"&gt;&lt;span style="FONT-FAMILY:Calibri;"&gt;&lt;span style="font-size:x-small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;span style="LINE-HEIGHT:115%;FONT-FAMILY:Consolas;COLOR:green;FONT-SIZE:9.5pt;mso-ansi-language:ES;mso-fareast-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-language:ES;mso-bidi-language:AR-SA;mso-bidi-font-family:Consolas;"&gt;
&lt;p class="MsoNormal"&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-family:Calibri;color:#000000;font-size:small;"&gt;Existe una inquietud por parte de muchas personas desde la aparici&amp;oacute;n de .NET, en tanto a como&amp;nbsp;descargar archivos utilizando una aplicaci&amp;oacute;n de escritorio desde un servidor FTP.&lt;/span&gt;&lt;/p&gt;
&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-family:Calibri;color:#000000;font-size:small;"&gt;El prop&amp;oacute;sito de este ejemplo es demostrar como descargar simult&amp;aacute;neamente archivos de un directorio ra&amp;iacute;z en un ftp, evidentemente con algunas limitaciones como por ejemplo navegar en los directorios del mismo. Me gustara compartir esta aplicaci&amp;oacute;n para que la ejecut&amp;eacute;is seg&amp;uacute;n os interese, intentare adaptar todas las sugerencias que me hag&amp;aacute;is llegar y finalmente poder publicar el proyecto (o eso espero) para compartirlo con todos vosotros.&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-family:Calibri;color:#000000;font-size:small;"&gt;Pod&amp;eacute;is descomprimir y ejecutar &amp;eacute;l &amp;lsquo;.exe&amp;rsquo; en cualquier maquina con Vista o 7, si necesit&amp;aacute;is el instalador no dud&amp;eacute;is en solicit&amp;aacute;rmelo, pero con en principio cualquier equipo con el Framework 3.5 sirve.&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-family:Calibri;color:#000000;font-size:small;"&gt;Espero vuestros comentarios.&lt;br /&gt;(C) Pep Lluis 2009 :-)&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;/span&gt;&lt;/td&gt;
&lt;td width="354" valign="top" style="padding-bottom:0cm;background-color:transparent;padding-left:5.4pt;width:265.15pt;padding-right:5.4pt;padding-top:0cm;border-color:#f0f0f0;"&gt;&lt;span lang="EN-US" style="mso-ansi-language:EN-US;"&gt;&lt;span style="FONT-SIZE:small;"&gt;&lt;span style="FONT-FAMILY:Calibri;"&gt;&lt;span style="FONT-FAMILY:&amp;#39;Times New Roman&amp;#39;, &amp;#39;serif&amp;#39;;COLOR:black;FONT-SIZE:12pt;mso-fareast-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-language:ES;"&gt;&lt;span lang="EN-US" style="LINE-HEIGHT:115%;FONT-FAMILY:Consolas;COLOR:green;FONT-SIZE:9.5pt;mso-ansi-language:EN-US;mso-bidi-font-family:Consolas;"&gt;
&lt;p class="MsoNormal"&gt;&lt;span lang="EN-US" style="mso-ansi-language:EN-US;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="color:#000000;"&gt;&lt;span style="font-family:Calibri;"&gt;&lt;br /&gt;Always receive some comments from people asking &amp;lsquo;How to Download files from FTP using .NET&amp;rdquo;, &lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&lt;/span&gt;the best way to answer this, is develop a very easy &amp;amp; simple sample using last version of framework, first I will share this app to free run and I will adapt all yours suggestions, finally share the project with source code (&amp;hellip; or I hope so). &lt;br style="mso-special-character:line-break;" /&gt;&lt;br style="mso-special-character:line-break;" /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span lang="EN-US" style="mso-ansi-language:EN-US;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="color:#000000;"&gt;&lt;span style="font-family:Calibri;"&gt;You can run with no setup in windows vista or 7, please ask if you need setup for deployment.&lt;br /&gt;&lt;br /&gt;Please don&amp;rsquo;t forget run and send your suggestions.&lt;br /&gt;Best!!&lt;br /&gt;Pep Lluis,&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;
&lt;p class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;
&lt;/p&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-family:Calibri;"&gt;&lt;b style="mso-bidi-font-weight:normal;"&gt;
&lt;p&gt;Puedes descargarte el ejecutable haciendo clic en : &lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Components.PostAttachments/00.01.74.46.28/ftpClient.zip" title="ftClient"&gt;FTPClient&lt;/a&gt;&lt;/p&gt;
&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-family:Calibri;"&gt;&lt;b style="mso-bidi-font-weight:normal;"&gt;Advertencia y Aclaraci&amp;oacute;n.&lt;br /&gt;Est&amp;aacute; claro que os facilito este articulo por vuestra insistencia, esta aplicaci&amp;oacute;n solo utiliza dos librer&amp;iacute;as :&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp; &lt;/span&gt;&lt;/b&gt;&lt;b style="mso-bidi-font-weight:normal;"&gt;&lt;span style="mso-no-proof:yes;mso-bidi-font-family:&amp;#39;Courier New&amp;#39;;"&gt;System.Net, System.IO &lt;/span&gt;y no almacena ning&amp;uacute;n tipo de informaci&amp;oacute;n introducida por nombres o credenciales intercambiadas por el usuario, &lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&lt;/span&gt;debo rechazar categ&amp;oacute;ricamente cualquier responsabilidad por el uso de la informaci&amp;oacute;n as&amp;iacute; como la aplicaci&amp;oacute;n aqu&amp;iacute; contenida, cualquier uso de la misma o de la informaci&amp;oacute;n de este art&amp;iacute;culo y su alcance es estrictamente responsabilidad del lector, aunque como siempre estar&amp;eacute; encantado de recibir vuestros comentarios.&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;b style="mso-bidi-font-weight:normal;"&gt;&lt;span lang="EN-US" style="mso-ansi-language:EN-US;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-family:Calibri;"&gt;Warning: &lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&lt;/span&gt;It is clear that this article is delivered for the insistence of some readers, this application uses only two libraries: System.NET, System.IO, does not store any information introduced by names or exchanged by the user credentials, I categorically reject any responsibility for the use of information as well as the application contained here, any use of it or the information in this article and its scope is strictly responsibility of the reader, although as I am always happy to receive your comments.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744628" width="1" height="1"&gt;</description><enclosure url="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Components.PostAttachments/00.01.74.46.28/ftpClient.zip" length="11048" type="application/x-zip-compressed" /><category domain="http://msmvps.com/blogs/peplluis/archive/tags/General/default.aspx">General</category><category domain="http://msmvps.com/blogs/peplluis/archive/tags/Visual+Studio/default.aspx">Visual Studio</category></item><item><title>El Registro: Editándolo</title><link>http://msmvps.com/blogs/juansa/archive/2009/12/10/el-registro-edit-225-ndolo.aspx</link><pubDate>Thu, 10 Dec 2009 10:40:03 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744620</guid><dc:creator>juansa</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Primero nos aseguramos que no hay nada que nos prohíba manipular el registro y que podemos añadir, eliminar o renombrar llaves y valores.&lt;/p&gt;  &lt;p&gt;Regedit nos muestra en pantalla un editor distinto dependiendo del tipo de valor:&lt;/p&gt;  &lt;table border="0" cellspacing="2" cellpadding="2" width="648"&gt;&lt;tbody&gt;     &lt;tr&gt;       &lt;td valign="top" width="292"&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/3733.registro_5F00_binario_5F00_2C77FDE1.jpg"&gt;&lt;img style="border-right-width:0px;display:block;float:none;border-top-width:0px;border-bottom-width:0px;margin-left:auto;border-left-width:0px;margin-right:auto;" title="registro_binario" border="0" alt="registro_binario" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/8611.registro_5F00_binario_5F00_thumb_5F00_0340F8DB.jpg" width="248" height="221" /&gt;&lt;/a&gt; &lt;/td&gt;        &lt;td valign="top" width="348"&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/8623.registro_5F00_MULTI_5F00_2F1E8D88.jpg"&gt;&lt;img style="border-right-width:0px;display:block;float:none;border-top-width:0px;border-bottom-width:0px;margin-left:auto;border-left-width:0px;margin-right:auto;" title="registro_MULTI" border="0" alt="registro_MULTI" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/2766.registro_5F00_MULTI_5F00_thumb_5F00_37F0FC56.jpg" width="244" height="220" /&gt;&lt;/a&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr&gt;       &lt;td valign="top" width="292"&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/0677.registro_5F00_cadena_5F00_0B8F0876.jpg"&gt;&lt;img style="border-right-width:0px;display:block;float:none;border-top-width:0px;border-bottom-width:0px;margin-left:auto;border-left-width:0px;margin-right:auto;" title="registro_cadena" border="0" alt="registro_cadena" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/7446.registro_5F00_cadena_5F00_thumb_5F00_29FE6AC1.jpg" width="259" height="168" /&gt;&lt;/a&gt; &lt;/td&gt;        &lt;td valign="top" width="348"&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/3324.registro_5F00_DWORD_5F00_42093B95.jpg"&gt;&lt;img style="border-right-width:0px;display:block;float:none;border-top-width:0px;border-bottom-width:0px;margin-left:auto;border-left-width:0px;margin-right:auto;" title="registro_DWORD" border="0" alt="registro_DWORD" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/7140.registro_5F00_DWORD_5F00_thumb_5F00_79DE1069.jpg" width="301" height="169" /&gt;&lt;/a&gt; &lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;  &lt;p&gt;El editor de cadena nos servirá en los tipos REG_SZ y REG_EXPAND_SZ, el DWORD para REG_DWORD, el binario para valores REG_BINARY, y el multi-string para los REG_MULTI_SZ.&lt;/p&gt;  &lt;p&gt;Para cambiar un valor, Editar, Modificar y escribir el nuevo valor dentro de la casilla correspondiente. Cuando cambiamos un valor éste se aplica de inmediato, aunque no signifique que Windows u otro programa incorporen el cambio. De hecho, hay cambios que hasta que el sistema o programa no se reinicien no se cargarán.&lt;/p&gt;  &lt;p&gt;Lo normal es realizar una copia de seguridad antes de modificar cualquier valor, no estamos libres de errores, para eso somos humanos.&lt;/p&gt;  &lt;p&gt;&lt;u&gt;Añadir llaves o valores&lt;/u&gt;&lt;/p&gt;  &lt;p&gt;Podemos crear llaves y valores sólo si sabemos lo que estamos haciendo:&lt;/p&gt;  &lt;ol&gt;   &lt;li&gt;Seleccionamos la llave donde añadir &lt;/li&gt;    &lt;li&gt;clic derecho, elegimos Nuevo &lt;/li&gt;    &lt;li&gt;Seleccionamos el tipo de valor     &lt;br /&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/7127.registro_5F00_addkey_5F00_3051531D.jpg"&gt;&lt;img style="border-right-width:0px;display:inline;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;" title="registro_addkey" border="0" alt="registro_addkey" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/3733.registro_5F00_addkey_5F00_thumb_5F00_45D12329.jpg" width="244" height="168" /&gt;&lt;/a&gt; &lt;/li&gt;    &lt;li&gt;Le damos un nombre y lo editamos para introducir el valor/es que deseamos. &lt;/li&gt; &lt;/ol&gt;  &lt;p&gt;&lt;u&gt;Borrar llaves o valores&lt;/u&gt;&lt;/p&gt;  &lt;p&gt;Deberíamos exportar aquéllas llaves/valores que vamos a eliminar, por seguridad.&lt;/p&gt;  &lt;p&gt;Clic derecho sobre el valor/llave y Eliminar&lt;/p&gt;  &lt;p&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/3733.registro_5F00_deletekey_5F00_4B44B52F.jpg"&gt;&lt;img style="border-bottom:0px;border-left:0px;display:inline;border-top:0px;border-right:0px;" title="registro_deletekey" border="0" alt="registro_deletekey" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/juansa.metablogapi/0020.registro_5F00_deletekey_5F00_thumb_5F00_2F5B324A.jpg" width="244" height="236" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;&lt;u&gt;Renombrar llaves o valores&lt;/u&gt;&lt;/p&gt;  &lt;p&gt;Clic en la llave/valor y renombrarlo. También podemos seleccionar con clic derecho la opción Cambiar nombre.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744620" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/juansa/archive/tags/Windows+Server/default.aspx">Windows Server</category></item><item><title>Another cool nudge: maintaining the selection of an element when using paging</title><link>http://msmvps.com/blogs/luisabreu/archive/2009/12/10/another-cool-nudge-maintaining-the-selection-of-an-element-when-using-paging.aspx</link><pubDate>Thu, 10 Dec 2009 10:24:42 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744617</guid><dc:creator>luisabreu</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;This is one of those simple things which really improves the use of controls like GridView and ListView. ASP.NET 4.0 adds the EnablePersistedSelection property to the GridView and ListView controls. To support this feature, the control ended up adding a new field (_persistedDataKey) which is saved in the control state of the control. Notice that what is persisted is the key that uniquely identifies the selected item (and not its position in the rows displayed by the grid.&lt;/p&gt;  &lt;p&gt;When the grid needs to create its rows, it will update the SelectedIndex (and other associated props) by checking the data key of each item it is rendering against the value persisted in the _persisteDataKey field. What this means is that when you change the page and go to a new one that doesn’t have the previous selected item, you’ll end up getting –1 for the SelectedIndex property. I guess this isn’t really the behavior you’d expect, but I’m assuming that it wasn’t changed so that it was backward compatible with previous versions (or it might end up breaking existing code). To recover the current selected item you’ll have to use the new SelectedPersistedKey property (which returns a DataKey object associated with the item that has been selected).&lt;/p&gt;  &lt;p&gt;And that’s it for now. Keep tuned for more&amp;#160; on ASP.NET.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744617" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/luisabreu/archive/tags/ASP.NET/default.aspx">ASP.NET</category></item><item><title>MCP Virtual Business Card</title><link>http://msmvps.com/blogs/clebermarques/archive/2009/12/10/mcp-virtual-business-card.aspx</link><pubDate>Thu, 10 Dec 2009 09:57:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744615</guid><dc:creator>Cleber Marques</dc:creator><slash:comments>0</slash:comments><description>&lt;p class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&lt;img border="0" src="http://www.clebermarques.com/blogimg/msvcard.jpg" style="max-width:550px;" alt="" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;Para quem quiser utilizar um sistema de cart&amp;otilde;es de visita, legal e gratuito, oferecido pela Microsoft esta &amp;eacute; uma boa oportunidade. No site &lt;a target="_blank" href="https://www.mcpvirtualbusinesscard.com/"&gt;&lt;span style="color:#0000ff;"&gt;mcpvirtualbusinesscard.com&lt;/span&gt;&lt;/a&gt; voc&amp;ecirc; pode criar um cart&amp;atilde;o personalizado, vale a pena testar, a chamada do site &amp;eacute;:&lt;/span&gt;&lt;/p&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;
&lt;table border="1" cellpadding="0" cellspacing="0" style="background:#eaf1dd;margin:auto auto auto 5.4pt;border-collapse:collapse;mso-yfti-tbllook:1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-border-insideh:.5pt solid #76923C;mso-border-insideh-themecolor:accent3;mso-border-insidev:.5pt solid #76923C;mso-border-alt:solid #76923C .5pt;mso-border-themecolor:accent3;mso-border-insidev-themecolor:accent3;mso-border-insideh-themeshade:191;mso-border-themeshade:191;mso-border-insidev-themeshade:191;mso-background-themecolor:accent3;mso-background-themetint:51;" class="MsoTableGrid"&gt;
&lt;tbody&gt;
&lt;tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes;"&gt;
&lt;td width="569" valign="top" style="padding-right:5.4pt;padding-left:5.4pt;padding-bottom:0cm;width:426.8pt;padding-top:0cm;background-color:transparent;mso-border-alt:solid #76923C .5pt;mso-border-themecolor:accent3;mso-border-themeshade:191;border:#76923c 1pt solid;"&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:EN-US;" lang="EN-US"&gt;Demonstrate your technology expertise and skills while expressing your virtual personality by creating your own, unique virtual business card and profile page to highlight your Microsoft certifications&lt;/span&gt;&lt;/p&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:EN-US;" lang="EN-US"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/p&gt;
&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:EN-US;" lang="EN-US"&gt;&lt;img border="0" src="http://www.clebermarques.com/blogimg/msvcardb.jpg" style="max-width:550px;" alt="" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;Obrigado pela leitura e at&amp;eacute; a pr&amp;oacute;xima publica&amp;ccedil;&amp;atilde;o,&lt;/span&gt;&lt;/p&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;Abra&amp;ccedil;os.&lt;/span&gt;&lt;/p&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p style="margin:0cm 0cm 0pt;line-height:normal;" class="MsoNormal"&gt;&lt;b&gt;&lt;span style="font-size:9pt;color:black;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;Cleber Marques&lt;/span&gt;&lt;/b&gt;&lt;span style="font-size:9pt;color:black;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&lt;span style="font-size:9pt;color:#595959;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-themecolor:text1;mso-themetint:166;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;Microsoft MVP &amp;amp; MCT | Charter Member: SCVMM &amp;amp; MDOP&lt;/span&gt;&lt;span style="font-size:9pt;color:black;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;&lt;br /&gt;Projeto MOF Brasil: Simplificando o Gerenciamento de Servi&amp;ccedil;os de TI&lt;br /&gt;&lt;/span&gt;&lt;span style="font-size:11pt;line-height:115%;font-family:&amp;#39;Calibri&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;"&gt;&lt;a target="_blank" href="http://msmvps.com/blogs/clebermarques"&gt;&lt;span style="font-size:9pt;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;Meu Blog&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;span style="font-size:9pt;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt; | &lt;/span&gt;&lt;span style="font-size:11pt;line-height:115%;font-family:&amp;#39;Calibri&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;"&gt;&lt;a target="_blank" href="http://www.mof.com.br/"&gt;&lt;span style="font-size:9pt;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&lt;span style="color:#0000ff;"&gt;MOF.com.br&lt;/span&gt;&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;span style="font-size:9pt;color:black;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt; | &lt;/span&gt;&lt;span style="font-size:11pt;line-height:115%;font-family:&amp;#39;Calibri&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;"&gt;&lt;a target="_blank" href="http://www.clebermarques.com/"&gt;&lt;span style="font-size:9pt;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&lt;span style="color:#0000ff;"&gt;CleberMarques.com&lt;/span&gt;&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;span style="font-size:9pt;color:black;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt; | &lt;/span&gt;&lt;span style="font-size:11pt;line-height:115%;font-family:&amp;#39;Calibri&amp;#39;,&amp;#39;sans-serif&amp;#39;;mso-ansi-language:PT-BR;mso-fareast-font-family:Calibri;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-fareast-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;"&gt;&lt;a target="_blank" href="http://www.canalsystemcenter.com.br/"&gt;&lt;span style="font-size:9pt;line-height:115%;font-family:&amp;#39;Verdana&amp;#39;,&amp;#39;sans-serif&amp;#39;;"&gt;&lt;span style="color:#0000ff;"&gt;CanalSystemCenter.com.br&lt;/span&gt;&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;/p&gt;
&lt;/span&gt;&lt;/p&gt;
&lt;p class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744615" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/clebermarques/archive/tags/Microsoft/default.aspx">Microsoft</category></item><item><title>Microsoft Security Bulletin Minor Revisions - December 9, 2009</title><link>http://msmvps.com/blogs/donpatterson/archive/2009/12/10/microsoft-security-bulletin-minor-revisions-december-9-2009.aspx</link><pubDate>Thu, 10 Dec 2009 09:15:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744608</guid><dc:creator>Don</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Issued: December 9, 2009&lt;br /&gt;&lt;br /&gt;&lt;span style="text-decoration:underline;"&gt;&lt;b&gt;Summary&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;The following bulletins have undergone a minor revision increment. &lt;br /&gt;Please see the appropriate bulletin for more details.&lt;br /&gt;&lt;br /&gt;  * MS09-073 - Important&lt;br /&gt;  * MS09-072 - Critical&lt;br /&gt;  * MS09-071 - Critical&lt;br /&gt;  * MS09-070 - Important&lt;br /&gt;  * MS09-058 - Important&lt;br /&gt;  * MS08-037 - Important&lt;br /&gt;&lt;br /&gt;&lt;span style="text-decoration:underline;"&gt;&lt;b&gt;Bulletin Information:&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;* &lt;b&gt;MS09-073 - Important&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;  - &lt;a class="moz-txt-link-freetext" href="http://www.microsoft.com/technet/security/bulletin/ms09-073.mspx"&gt;http://www.microsoft.com/technet/security/bulletin/ms09-073.mspx&lt;/a&gt;&lt;br /&gt;  - Reason for Revision: V1.1 (December 9, 2009): Removed a redundant&lt;br /&gt;    entry for the Microsoft Office Compatibility Pack from the&lt;br /&gt;    non-affected software table. Also corrected several&lt;br /&gt;    deployment reference tables to clarify that in some cases,&lt;br /&gt;    this update does not require a restart. This is an&lt;br /&gt;    informational change only.   &lt;br /&gt;  - Originally posted: December 8, 2009&lt;br /&gt;  - Updated: December 9, 2009&lt;br /&gt;  - Bulletin Severity Rating: Important&lt;br /&gt;  - Version: 1.1&lt;br /&gt;    &lt;br /&gt;* &lt;b&gt;MS09-072 - Critical&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;  - &lt;a class="moz-txt-link-freetext" href="http://www.microsoft.com/technet/security/bulletin/ms09-072.mspx"&gt;http://www.microsoft.com/technet/security/bulletin/ms09-072.mspx&lt;/a&gt;&lt;br /&gt;  - Reason for Revision: V1.1 (December 9, 2009): Corrected a&lt;br /&gt;    reference to Microsoft Knowledge Base Article 976749 in the&lt;br /&gt;    section, Frequently Asked Questions (FAQ) Related to This&lt;br /&gt;    Security Update. Also corrected, in the Security Update&lt;br /&gt;    Deployment section, the registry key for verification of the&lt;br /&gt;    update for Internet Explorer 7 for all supported x64-based&lt;br /&gt;    editions of Windows XP.  &lt;br /&gt;  - Originally posted: December 8, 2009&lt;br /&gt;  - Updated: December 9, 2009&lt;br /&gt;  - Bulletin Severity Rating: Critical&lt;br /&gt;  - Version: 1.1&lt;br /&gt;    &lt;br /&gt;* &lt;b&gt;MS09-071 - Critical&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;  - &lt;a class="moz-txt-link-freetext" href="http://www.microsoft.com/technet/security/bulletin/ms09-071.mspx"&gt;http://www.microsoft.com/technet/security/bulletin/ms09-071.mspx&lt;/a&gt;&lt;br /&gt;  - Reason for Revision: V1.1 (December 9, 2009): Added an entry to&lt;br /&gt;    the Frequently Asked Questions (FAQ) Related to This Security&lt;br /&gt;    Update section to explain this revision. This is an&lt;br /&gt;    informational change only.  &lt;br /&gt;  - Originally posted: December 8, 2009&lt;br /&gt;  - Updated: December 9, 2009&lt;br /&gt;  - Bulletin Severity Rating: Critical&lt;br /&gt;  - Version: 1.1&lt;br /&gt;    &lt;br /&gt;* &lt;b&gt;MS09-070 - Important&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;  - &lt;a class="moz-txt-link-freetext" href="http://www.microsoft.com/technet/security/bulletin/ms09-070.mspx"&gt;http://www.microsoft.com/technet/security/bulletin/ms09-070.mspx&lt;/a&gt;&lt;br /&gt;  - Reason for Revision: V1.1 (December 9, 2009): Corrected the SMS&lt;br /&gt;    2.0 and SMS 2003 with SUIT entries for Windows Server 2003&lt;br /&gt;    x64 Edition Service Pack 2 in the SMS table. This is an&lt;br /&gt;    information change only.  &lt;br /&gt;  - Originally posted: December 8, 2009&lt;br /&gt;  - Updated: December 9, 2009&lt;br /&gt;  - Bulletin Severity Rating: Important&lt;br /&gt;  - Version: 1.1&lt;br /&gt;    &lt;br /&gt;* &lt;b&gt;MS09-058 - Important&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;  - &lt;a class="moz-txt-link-freetext" href="http://www.microsoft.com/technet/security/bulletin/ms09-058.mspx"&gt;http://www.microsoft.com/technet/security/bulletin/ms09-058.mspx&lt;/a&gt;&lt;br /&gt;  - Reason for Revision: V1.1 (December 9, 2009): Added a link to&lt;br /&gt;    Microsoft Knowledge Base Article 971486 under Known Issues in&lt;br /&gt;    the Executive Summary.  &lt;br /&gt;  - Originally posted: October 13, 2009&lt;br /&gt;  - Updated: December 9, 2009&lt;br /&gt;  - Bulletin Severity Rating: Important&lt;br /&gt;  - Version: 1.1&lt;br /&gt;    &lt;br /&gt;* &lt;b&gt;MS08-037 - Important&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;  - &lt;a class="moz-txt-link-freetext" href="http://www.microsoft.com/technet/security/bulletin/ms08-037.mspx"&gt;http://www.microsoft.com/technet/security/bulletin/ms08-037.mspx&lt;/a&gt;&lt;br /&gt;  - Reason for Revision: V3.1 (December 9, 2009): Corrected the&lt;br /&gt;    registry key verification and removal information in the&lt;br /&gt;    reference table for the DNS client on Microsoft Windows 2000&lt;br /&gt;    Service Pack 4 (KB951748). This is an informational change only.  &lt;br /&gt;  - Originally posted: July 8, 2008&lt;br /&gt;  - Updated: December 9, 2009&lt;br /&gt;  - Bulletin Severity Rating: Important&lt;br /&gt;  - Version: 3.1&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744608" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/donpatterson/archive/tags/Advisories+_2F00_+Bulletins/default.aspx">Advisories / Bulletins</category></item><item><title>[MS Security] Bulletin Minor Revisions - Issued: December 9, 2009</title><link>http://msmvps.com/blogs/chobbs/archive/2009/12/10/ms-security-bulletin-minor-revisions-issued-december-9-2009.aspx</link><pubDate>Thu, 10 Dec 2009 09:11:24 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744619</guid><dc:creator>Cliff Hobbs at myITforum.com</dc:creator><slash:comments>0</slash:comments><description>Summary The following bulletins have undergone a minor revision increment. Please see the appropriate bulletin for more details. &amp;#160; * MS09-073 - Important &amp;#160; * MS09-072 - Critical &amp;#160; * MS09-071 - Critical &amp;#160; * MS09-070 - Important &amp;#160; Read More......(&lt;a href="http://msmvps.com/blogs/chobbs/archive/2009/12/10/ms-security-bulletin-minor-revisions-issued-december-9-2009.aspx"&gt;read more&lt;/a&gt;)&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744619" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/chobbs/archive/tags/General/default.aspx">General</category><category domain="http://msmvps.com/blogs/chobbs/archive/tags/MS+Security/default.aspx">MS Security</category></item><item><title>Microsoft Exchange 2010 Rollup 1 ist verfügbar</title><link>http://msmvps.com/blogs/wstein/archive/2009/12/10/microsoft-exchange-2010-rollup-1-ist-verf-252-gbar.aspx</link><pubDate>Thu, 10 Dec 2009 08:13:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744598</guid><dc:creator>Wstein</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Bereits wenige Wochen nach dem Erscheinen der RTM-Version von Exchange 2010 bringt Microsoft das erste Rollup-Packet heraus. Den KB-Artikel mit dem darin enhaltenen Download-Link findet ihr an folgender Stelle:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href="http://support.microsoft.com/kb/976573"&gt;http://support.microsoft.com/kb/976573&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Happy Patching&lt;/p&gt;
&lt;p&gt;Viele Gr&amp;uuml;&amp;szlig;e&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Walter Steinsdorfer&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744598" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/wstein/archive/tags/Exchange/default.aspx">Exchange</category></item><item><title>BlackBerry Enterprise Server und Exchange Server 2010 – jetzt supported</title><link>http://msmvps.com/blogs/rauscher/archive/2009/12/10/blackberry-enterprise-server-und-exchange-server-2010-jetzt-supported.aspx</link><pubDate>Thu, 10 Dec 2009 08:08:46 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744596</guid><dc:creator>rauscher</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Ab sofort wird eine BES-Installation in einer Exchange Server 2010-Umgebung unterstützt. Dazu sind drei Updates erforderlich:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;&lt;a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=371add31-d7a0-4c8b-8325-a6fced2d05e6&amp;amp;displaylang=en" target="_blank"&gt;Roll-Up 1 (RU1) for Exchange Server 2010&lt;/a&gt;&lt;/li&gt;    &lt;li&gt;&lt;a href="http://www.microsoft.com/downloads/details.aspx?familyid=e17e7f31-079a-43a9-bff2-0a110307611e&amp;amp;displaylang=en" target="_blank"&gt;MAPI v6.5.8147&lt;/a&gt;&lt;/li&gt;    &lt;li&gt;&lt;a href="http://www.blackberry.com/support/downloads" target="_blank"&gt;BlackBerry Enterprise Server 5.0.1 Maintenance Release 1 (MR1)&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Bevor das MR1 installiert werden kann, muss natürlich zuerst das Service Pack 1 für den BES 5.0 drauf, sofern das noch nicht geschehen ist.&lt;/p&gt;  &lt;p&gt;Weitere Informationen:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;&lt;a href="http://msexchangeteam.com/archive/2009/12/09/453486.aspx" target="_blank"&gt;Exchange Team Blogeintrag&lt;/a&gt;&lt;/li&gt;    &lt;li&gt;&lt;a href="http://na.blackberry.com/eng/support/software/server_compatibility.jsp#tab_tab_news" target="_blank"&gt;BlackBerry Enterprise Server Compatibility&lt;/a&gt;&lt;/li&gt;    &lt;li&gt;&lt;a href="http://na.blackberry.com/eng/services/server/exchange/2010support.jsp" target="_blank"&gt;BlackBerry Enterprise Server Support for Microsoft Exchange Server 2010&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Viele Grüße    &lt;br /&gt;Dieter     &lt;br /&gt;    &lt;br /&gt;--     &lt;br /&gt;Dieter Rauscher     &lt;br /&gt;MVP Forefront&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744596" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/rauscher/archive/tags/BlackBerry/default.aspx">BlackBerry</category><category domain="http://msmvps.com/blogs/rauscher/archive/tags/Exchange+Server+2010/default.aspx">Exchange Server 2010</category></item><item><title>Exchange Server 2010 Update Rollup 1 verfuegbar</title><link>http://msmvps.com/blogs/rauscher/archive/2009/12/10/exchange-server-2010-update-rollup-1-verfuegbar.aspx</link><pubDate>Thu, 10 Dec 2009 07:59:47 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744591</guid><dc:creator>rauscher</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Für den Exchange Server 2010 ist das erste Update Rollup verfügbar.&lt;/p&gt;  &lt;p&gt;Weitere Informationen:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;&lt;a href="http://support.microsoft.com/kb/976573" target="_blank"&gt;KB976573 Description of Update Rollup 1 for Exchange Server 2010&lt;/a&gt;&lt;/li&gt;    &lt;li&gt;&lt;a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=371add31-d7a0-4c8b-8325-a6fced2d05e6&amp;amp;displaylang=en" target="_blank"&gt;Downloadmöglichkeit&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Viele Grüße    &lt;br /&gt;Dieter     &lt;br /&gt;    &lt;br /&gt;--     &lt;br /&gt;Dieter Rauscher     &lt;br /&gt;MVP Forefront&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744591" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/rauscher/archive/tags/Exchange+Server+2010/default.aspx">Exchange Server 2010</category></item><item><title>Internet Information Services 6.0 may not function correctly after installing KB973917</title><link>http://msmvps.com/blogs/bradley/archive/2009/12/09/internet-information-services-6-0-may-not-function-correctly-after-installing-kb973917.aspx</link><pubDate>Thu, 10 Dec 2009 06:44:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744575</guid><dc:creator>bradley</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Watch out for the Extended Authentication update issue...&lt;/p&gt;
&lt;p&gt;Internet Information Services 6.0 may not function correctly after installing KB973917&lt;/p&gt;
&lt;p&gt;&lt;a href="http://support.microsoft.com/kb/2009746"&gt;http://support.microsoft.com/kb/2009746&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;em&gt;Consider the following scenario.&amp;nbsp; You have an Internet Information Services (IIS) 6.0 web server running on Windows Server 2003 Service Pack 2.&amp;nbsp;&amp;nbsp;The Microsoft update KB973917 gets installed on the server.&amp;nbsp; After installing KB973917, the IIS 6.0 application pools cannot start up successfully.&amp;nbsp;&lt;/em&gt;&lt;/p&gt;
&lt;p&gt;&lt;em&gt;Previous to the installation of the KB973917 update, one or more of the core IIS .dll files were not at the correct file version.&amp;nbsp; Specifically, the earlier&amp;nbsp;installation of Windows Server 2003 Service Pack 2 on the server did not complete successfully, leaving some of the IIS .dlls at the Service Pack 1 level while bringing others up to the Service Pack 2 level.&amp;nbsp; The IIS services had been able to run successfully even with that file mismatch in place.&amp;nbsp; However, the installation of the KB973917 update exposes this pre-existing file mismatch environment to the degree that IIS is now unable to function properly.&lt;/em&gt;&lt;/p&gt;
&lt;p&gt;&lt;em&gt;To resolve this problem, reinstall Service Pack 2 for Windows Server 2003 on the web server.&amp;nbsp; This will bring all IIS 6.0 components up to the correct file versions, and will maintain the installation of the KB973917 update.&amp;nbsp; Reinstalling the KB973917 update should not be necessary.&lt;/em&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744575" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/bradley/archive/tags/Security/default.aspx">Security</category></item><item><title>Exchange Server 2010 RU1 and BES supportability</title><link>http://msmvps.com/blogs/andersonpatricio/archive/2009/12/09/exchange-server-2010-ru1-and-bes-supportability.aspx</link><pubDate>Thu, 10 Dec 2009 01:34:27 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744539</guid><dc:creator>Anderson Patricio</dc:creator><slash:comments>0</slash:comments><description>
&lt;p&gt;Hi Folks,&lt;/p&gt;
&lt;p&gt;RU 1 was released ( &lt;a href="http://support.microsoft.com/kb/976573"&gt;http://support.microsoft.com/kb/976573&lt;/a&gt;) and BES is also fully supported on Exchange Server 2010.&lt;/p&gt;
&lt;p&gt;Read more at source: &lt;a href="http://msexchangeteam.com/archive/2009/12/09/453486.aspx"&gt;http://msexchangeteam.com/archive/2009/12/09/453486.aspx&lt;/a&gt; and &lt;a href="http://msexchangeteam.com/archive/2009/12/09/453485.aspx"&gt;http://msexchangeteam.com/archive/2009/12/09/453485.aspx&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Cheers,
&lt;br /&gt;
&lt;strong&gt;Anderson Patricio&lt;/strong&gt;&lt;/p&gt;
&lt;p class="zoundry_raven_tags"&gt;
  
  &lt;span class="ztags"&gt;&lt;span class="ztagspace"&gt;Technorati&lt;/span&gt; : &lt;a href="http://www.technorati.com/tag/BES" class="ztag" rel="tag"&gt;BES&lt;/a&gt;, &lt;a href="http://www.technorati.com/tag/Exchange+Server+2010" class="ztag" rel="tag"&gt;Exchange Server 2010&lt;/a&gt;, &lt;a href="http://www.technorati.com/tag/Rollup+Update+1" class="ztag" rel="tag"&gt;Rollup Update 1&lt;/a&gt;&lt;/span&gt;  &lt;br /&gt;
 &lt;span class="ztags"&gt;&lt;span class="ztagspace"&gt;Del.icio.us&lt;/span&gt; : &lt;a href="http://del.icio.us/tag/BES" class="ztag" rel="tag"&gt;BES&lt;/a&gt;, &lt;a href="http://del.icio.us/tag/Exchange%20Server%202010" class="ztag" rel="tag"&gt;Exchange Server 2010&lt;/a&gt;, &lt;a href="http://del.icio.us/tag/Rollup%20Update%201" class="ztag" rel="tag"&gt;Rollup Update 1&lt;/a&gt;&lt;/span&gt;  &lt;br /&gt;
 &lt;span class="ztags"&gt;&lt;span class="ztagspace"&gt;Zooomr&lt;/span&gt; : &lt;a href="http://www.zooomr.com/search/photos/?q=BES" class="ztag" rel="tag"&gt;BES&lt;/a&gt;, &lt;a href="http://www.zooomr.com/search/photos/?q=Exchange%20Server%202010" class="ztag" rel="tag"&gt;Exchange Server 2010&lt;/a&gt;, &lt;a href="http://www.zooomr.com/search/photos/?q=Rollup%20Update%201" class="ztag" rel="tag"&gt;Rollup Update 1&lt;/a&gt;&lt;/span&gt;  &lt;br /&gt;
 &lt;span class="ztags"&gt;&lt;span class="ztagspace"&gt;Flickr&lt;/span&gt; : &lt;a href="http://www.flickr.com/photos/tags/BES" class="ztag" rel="tag"&gt;BES&lt;/a&gt;, &lt;a href="http://www.flickr.com/photos/tags/Exchange%20Server%202010" class="ztag" rel="tag"&gt;Exchange Server 2010&lt;/a&gt;, &lt;a href="http://www.flickr.com/photos/tags/Rollup%20Update%201" class="ztag" rel="tag"&gt;Rollup Update 1&lt;/a&gt;&lt;/span&gt; 
&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744539" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/andersonpatricio/archive/tags/Exchange+2010/default.aspx">Exchange 2010</category></item><item><title>Microsoft and Research in Motion announce full BES support for Exchange 2010</title><link>http://msmvps.com/blogs/exchangepedia/archive/2009/12/09/microsoft-and-research-in-motion-announce-full-bes-support-for-exchange-2010.aspx</link><pubDate>Thu, 10 Dec 2009 00:00:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744526</guid><dc:creator>Exchangepedia Blog</dc:creator><slash:comments>0</slash:comments><description>Read More......(&lt;a href="http://msmvps.com/blogs/exchangepedia/archive/2009/12/09/microsoft-and-research-in-motion-announce-full-bes-support-for-exchange-2010.aspx"&gt;read more&lt;/a&gt;)&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744526" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/exchangepedia/archive/tags/Newsbytes/default.aspx">Newsbytes</category><category domain="http://msmvps.com/blogs/exchangepedia/archive/tags/Microsoft/default.aspx">Microsoft</category><category domain="http://msmvps.com/blogs/exchangepedia/archive/tags/Mobility+-+BES_2F00_ActiveySync/default.aspx">Mobility - BES/ActiveySync</category><category domain="http://msmvps.com/blogs/exchangepedia/archive/tags/Exchange+2010/default.aspx">Exchange 2010</category></item><item><title>Did you know there's a SBS 2008 app catalog?</title><link>http://msmvps.com/blogs/bradley/archive/2009/12/09/did-you-know-there-s-a-sbs-2008-app-catalog.aspx</link><pubDate>Wed, 09 Dec 2009 22:11:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744500</guid><dc:creator>bradley</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&lt;a href="http://www.microsoft.com/sbs/en/us/catalog.aspx"&gt;http://www.microsoft.com/sbs/en/us/catalog.aspx&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Found out from Dana today that there&amp;#39;s a SBS 2008 officially supported applications catalog that lists those vendors that specifically support SBS 2008.&lt;/p&gt;
&lt;div class="cueSection marginTop20"&gt;
&lt;div class="cueImageBlock marginTop15"&gt;&lt;a href="http://www.authanvil.com/"&gt;&lt;img height="50" width="145" src="http://i.microsoft.com/global/sbs/en/us/PublishingImages/SoftSolu-AuthAnvil_145x50px.jpg" alt="Scorpion Software AuthAnvil " /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class="cueSection marginTop5"&gt;&lt;a href="http://www.authanvil.com/" title="Scorpion Software AuthAnvil " class="cueLinkBlock  normal"&gt;Scorpion Software AuthAnvil &lt;/a&gt;
&lt;p class="cueParagraph"&gt;AuthAnvil enhances the security and productivity of remote access through identity assurance and strong two-factor authentication for Windows Essential Server Solutions.&lt;/p&gt;
&lt;/div&gt;
&lt;h3 class="cueSectionTitle"&gt;Windows Small Business Server 2008 Supporting Applications&lt;/h3&gt;
&lt;p class="cueParagraph"&gt;Many independent software vendors (ISVs) are supporting Windows Small Business Server 2008 (SBS 2008), across a wide variety of applications that are critical to small businesses. In addition to the solutions listed here, SBS 2008 will run any applications certified on Windows Server 2008 listed here: &lt;a href="http://www.windowsservercatalog.com/" title="http://www.windowsservercatalog.com/"&gt;http://www.windowsservercatalog.com/&lt;/a&gt;. &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744500" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/bradley/archive/tags/News/default.aspx">News</category></item><item><title>InstallShield LE for Visual Studio 2010 (Beta) now available</title><link>http://msmvps.com/blogs/installsite/archive/2009/12/09/installshield-le-for-visual-studio-2010-beta-now-available.aspx</link><pubDate>Wed, 09 Dec 2009 21:24:57 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1744494</guid><dc:creator>stefan</dc:creator><slash:comments>3</slash:comments><description>&lt;p&gt;As &lt;a href="http://msmvps.com/blogs/installsite/archive/2009/11/02/visual-studio-2010-beta-2-includes-link-to-installshield-limited-edition.aspx" target="_blank"&gt;reported before&lt;/a&gt;, Visual Studio 2010 (currently in beta) includes an &amp;quot;InstallShield 2010&amp;quot; project template in the &amp;quot;Setup and Deployment&amp;quot; category. Back then the link didn&amp;#39;t work, but now it&amp;#39;s live. From the &amp;quot;InstallShield Limited Edition for Microsoft Visual Studio 2010&amp;quot; page you can now download a setup package. Registration is required before you can start the download, and my standard Flexera privacy caveat applies: Anyone who knows your e-mail address can retrieve the other information you entered in this form, like your real name, phone number, company name, city and country.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/installsite.metablogapi/4401.ISLERegistration_5F00_23D1272B.png"&gt;&lt;img style="border-right-width:0px;display:inline;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;" title="ISLE-Registration" border="0" alt="ISLE-Registration" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/installsite.metablogapi/2251.ISLERegistration_5F00_thumb_5F00_7FE84FD0.png" width="597" height="484" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;According to the download page: &amp;quot;InstallShield Limited Edition for Visual Studio 2010 replaces the functionality provided by the Visual Studio Installer tool. It provides a subset of the world-class functionality found in our more advanced InstallShield editions.&amp;quot;. Note that installing InstallShield LE doesn&amp;#39;t remove the Visual Studio Installer (VSI) project type, but it offers an alternative. &lt;/p&gt;  &lt;p&gt;&lt;a href="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/installsite.metablogapi/3817.ISLESolutionExplorer_5F00_15EEBB63.png"&gt;&lt;img style="border-right-width:0px;display:inline;border-top-width:0px;border-bottom-width:0px;margin-left:0px;border-left-width:0px;margin-right:0px;" title="ISLE-Solution-Explorer" border="0" alt="ISLE-Solution-Explorer" align="right" src="http://msmvps.com/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/installsite.metablogapi/7115.ISLESolutionExplorer_5F00_thumb_5F00_1EFB46E4.png" width="281" height="710" /&gt;&lt;/a&gt;Now the interesting question is what subset of the full InstallShield functionality is included in the Limited Edition, and what has been removed? I haven&amp;#39;t seen this officially documented, so here are the most notable differences I found so far. (In this screen shot of Solution Explorer you can see the disabled views marked with a lock symbol)&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;You are limited to one InstallShield project type, probably the equivalent to &amp;quot;Basic MSI&amp;quot;. Other project types like Merge Module, InstallScript or Smart Device are not included. &lt;/li&gt;    &lt;li&gt;You cannot customize the Feature structure of your setup. So you are limited to one feature, similar to VSI. &lt;/li&gt;    &lt;li&gt;There are no localization options. Multi language setups are only supported in the Premier edition of InstallShield. &lt;/li&gt;    &lt;li&gt;Text File Changes and XML File Changes views are disabled. &lt;/li&gt;    &lt;li&gt;SQL Scripts and COM registration are unavailable. &lt;/li&gt;    &lt;li&gt;Billboards and Support Files can&amp;#39;t be specified. &lt;/li&gt;    &lt;li&gt;Dependency Scanners are not included (but it&amp;#39;s always better to know your runtime dependencies than having a machine trying to guess) &lt;/li&gt;    &lt;li&gt;The Patch Design view is also been locked. &lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;While some more important and some less important functionality has been disabled in the Limited Edition, InstallShield LE still offers some advantages compared to Visual Studio Installer:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Prerequiste installation to pre-install packages like the .NET Framework or Internet Explorer 8. &lt;/li&gt;    &lt;li&gt;INI File Changes and Environment Variables views. &lt;/li&gt;    &lt;li&gt;IIS configuration view. &lt;/li&gt;    &lt;li&gt;More dialogs to chose from, but only limited customization options (similar to InstallShield Express). &lt;/li&gt;    &lt;li&gt;Slightly more custom action scheduling options, but by far not equivalent to the full InstallShield version. Essentially you can call a custom action at the beginning or at the end of the UI sequence, or in the Execute sequence after RegisterProduct. In VSI you can&amp;#39;t insert custom actions in the UI sequence at all. &lt;/li&gt;    &lt;li&gt;More customization options for Major Upgrades (in the &amp;quot;Upgrade Paths&amp;quot; view) &lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Like in the full InstallShield version, the &amp;quot;Update Notifications&amp;quot; view enables you to register your product with FlexNet Connect to send automatic updates to your customers. However this requires a FlexNet Connect account which is sold separately.&lt;/p&gt;  &lt;p&gt;InstallShield LE has a wizard to import VSI projects.&lt;/p&gt;  &lt;p&gt;To summarize, it looks like InstallShield LE has been tailored to be a replacement for Visual Studio Installer, only adding a limited amount of extra functionality. The big advantage is that you can move to the more powerful InstallShield editions whenever you need the full functionality, without having to start over, and that you are already familiar with the InstallShield user interface. Ideally, the upgrade would simply remove some lock icons from the list of editors in Solution Explorer.    &lt;br clear="all" /&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1744494" width="1" height="1"&gt;</description><category domain="http://msmvps.com/blogs/installsite/archive/tags/Windows+Installer/default.aspx">Windows Installer</category><category domain="http://msmvps.com/blogs/installsite/archive/tags/Industry+News/default.aspx">Industry News</category><category domain="http://msmvps.com/blogs/installsite/archive/tags/Visual+Studio/default.aspx">Visual Studio</category><category domain="http://msmvps.com/blogs/installsite/archive/tags/InstallShield/default.aspx">InstallShield</category><category domain="http://msmvps.com/blogs/installsite/archive/tags/Flexera/default.aspx">Flexera</category><category domain="http://msmvps.com/blogs/installsite/archive/tags/Microsoft/default.aspx">Microsoft</category><category domain="http://msmvps.com/blogs/installsite/archive/tags/MSI/default.aspx">MSI</category></item></channel></rss>