Windows Tips & Tricks UPDATE--April 2, 2007: Extracting Content from an MSU File

Subscribe to Windows IT Pro: https://store.pentontech.com/index.cfm?s=1&promocode=eu205xxL

====================

THESE COMPANIES HELP BRING YOU WINDOWS TIPS & TRICKS UPDATE FREE OF CHARGE.

NETWORK TESTING LABS COMPARES ARGENT TO MOM 2005
http://www.argent.com/w/whitepapers_mom.html?Source=WNT

Securing Online Data Transfer with SSL
http://www.windowsitpro.com/go/whitepaper/thawte/ssl?code=T&TMid0402

Building ROI with Your Email System
http://www.windowsitpro.com/go/whitepapers/iLumin/email/?code=T&THot0402

==== Sponsor: Argent Software ====

NETWORK TESTING LABS COMPARES ARGENT TO MOM 2005 Network Testing Labs, one of the world's leading independent research companies, concluded that "Argent's suite had a smaller footprint, was more scalable, supported more platforms, had a more responsive and intuitive user interface and gave us more useful reports," the report says. "Argent's suite of monitoring products emerged from our testing with flying colors."

Download this FREE Comparison Paper now: http://www.argent.com/w/whitepapers_mom.html?Source=WNT

====================

FAQs
Q. How can I extract the files from a Windows Vista Microsoft Update Standalone Package (MSU)?
Q. How can I check driver availability for my Creative Technology product under Windows Vista?
Q. Can I upgrade to Microsoft Exchange Server 2007 from Exchange Server 5.5?
Q. What is the new licensing scheme that is part of Microsoft SQL Server 2005 Service Pack 2 (SP2)?
Q. How do I insert a single quote (') into a SQL Server database?

==== Sponsor: Thawte ====

Securing Online Data Transfer with SSL

Protect your Internet communication and online activity from eavesdropping, electronic tampering and other malicious activity. Secure an e-commerce Web site or digital resource and gain the trust of your users and customers - all using Secure Socket Layers (SSL). Download a free copy of the Thawte SSL Guide to learn how it can be deployed to protect your business.
http://www.windowsitpro.com/go/whitepaper/thawte/ssl?code=T&TMid0402

====================

==== FAQs ====
by John Savill, FAQ Editor, [email protected]

Q. How can I extract the files from a Windows Vista Microsoft Update Standalone Package (MSU)?

A. The new MSU format doesn't support the old /x type switches to extract the content. It also can't be run on a pre-Vista OS. To extract the content from an MSU file, you need to use the Expand command that's part of Vista. Note that the Expand command from earlier versions of Windows are different and won't work. Use the -F switch to extract the content, as the following example shows:

D:temp>mkdir msu

D:temp>expand -F:* Windows6.0-KB929761-x86.msu d:tempmsu

The command produces the following output:

Adding d:tempmsuWSUSSCAN.cab to Extraction Queue
Adding d:tempmsuWindows6.0-KB929761-x86.cab to Extraction Queue
Adding d:tempmsuWindows6.0-KB929761-x86-pkgProperties.txt to Extraction Queue

Adding d:tempmsuWindows6.0-KB929761-x86.xml to Extraction Queue

Expanding Files ...

Expanding Files Complete ... 4 files total.

At this point, the .cab files, which contain the actual files, are still not extracted, so now run the extract command on the cab file, as the following command and resulting output shows:

D:temp>expand -F:* d:tempmsuWindows6.0-KB929761-x86.cab d:tempmsu

Adding d:tempmsuupdate.mum to Extraction Queue
Adding d:tempmsux86_microsoft-windows-wusa_31bf3856ad364e35_6.0.6000.20496_no
ne_ab489c6034d78613.manifest to Extraction Queue
Adding d:tempmsux86_microsoft-windows-
wusa_31bf3856ad364e35_6.0.6000.16400_no
ne_ab1a4f0b1b764fed.manifest to Extraction Queue
Adding d:tempmsuupdate-bf.mum to Extraction Queue
Adding d:tempmsux86_microsoft-windows-
wusa.d_31bf3856ad364e35_6.0.6000.20496_
none_4632ef2815ba2cfd.manifest to Extraction Queue
Adding d:tempmsux86_microsoft-windows-
wusa.d_31bf3856ad364e35_6.0.6000.16400_
none_4604a1d2fc58f6d7.manifest to Extraction Queue
Adding d:tempmsuupdate.cat to Extraction Queue
Adding d:tempmsuupdate-bf.cat to Extraction Queue
Adding d:tempmsux86_microsoft-windows-
wusa_31bf3856ad364e35_6.0.6000.16400_no
ne_ab1a4f0b1b764fedwusa.exe to Extraction Queue
Adding d:tempmsux86_microsoft-windows-
wusa_31bf3856ad364e35_6.0.6000.20496_no
ne_ab489c6034d78613wusa.exe to Extraction Queue

Expanding Files ....

Expanding Files Complete ... 10 files total. --------------------

Q. How can I check driver availability for my Creative Technology product under Windows Vista?

A. Creative maintains a list of Vista drivers for all its hardware at http://us.creative.com/support/kb/article.asp?sid=14186 .

--------------------

Q. Can I upgrade to Microsoft Exchange Server 2007 from Exchange Server 5.5?

A. No. You can't introduce Exchange 2007 into an existing Exchange organization while an Exchange 5.5 server still exists in the organization. If you run Exchange 5.5, you must first upgrade to Exchange 2000 Server or Exchange Server 2003, effectively Exchange native mode. After you move the mailboxes to an Exchange 2000 or Exchange 2003 organization, you can move the mailboxes to Exchange 2007 via the Exchange 2007 GUI if Exchange 2007 and the Exchange 2003/2000 installation are in the same organization or by using the Power Shell Move-Mailbox command for cross-organization migrations.

--------------------

Q. What is the new licensing scheme that is part of Microsoft SQL Server 2005 Service Pack 2 (SP2)?

A. With SQL Server 2005 SP2, you can now run an unlimited number of virtual instances of SQL Server on a physical box that's licensed for SQL Server 2005 Enterprise Edition. This will allow organizations to try new combinations of SQL Server instances to test the performance of their servers. --------------------

Q. How do I insert a single quote (') into a SQL Server database?

A. Usually the single quote character is reserved for inserting information into a database. If a single quote is contained in the actual data to be inserted, the command often becomes corrupted. To solve the problem simply replace any single quote with two quotes (not the double quote character but two single quote characters. The sample command below performs this replacement automatically:

sContent = Replace(sContent,"'","'")

where sContent contains the data that needs single quotes replaced so that the data can be inserted into a database.

--------------------

==== Hot Release ====

Building ROI with Your Email System

Is your company addressing the risks of email without diluting the benefits of email? In this free white paper discover the ROI associated with deployment of an email archiving solution. You'll learn that total potential return requires a full-featured message management system that addresses all the enterprise cost centers surrounding email. Download this guide today and find out what you can do to realize the dramatic and quantifiable ROI that will move your company quickly from analyzing options and seeking budget approval to solving the problem with a solution that will pay for itself many times over.
http://www.windowsitpro.com/go/whitepapers/iLumin/email/?code=T&THot0402

==== Events and Resources ==== http://www.windowsitpro.com/events

Do you have visibility and control over your software licenses? Most organizations face serious challenges, including complex and confusing vendor licensing models, cost overruns, missed deadlines and business opportunities, and lost user productivity. Learn to address these challenges and prepare for audits. Register for this free on-demand Web seminar, available now!
http://www.windowsitpro.com/go/seminars/macrovision/softwarelicensing/?partnerref=0402e&r

Having customers depend on your IT services in order to communicate, purchase, or manage orders is great for your business. But what happens when your applications or Web sites become unavailable? Download this free white paper and learn how to eliminate application downtime disruptions and ensure the continuity of your business.
http://www.windowsitpro.com/go/whitepaper/neverfail/businesscontinuity/?code=0402e&r

You know you need to manage your email data, but how do you do it? What steps do you need to take? What additional measures should you enact? What shouldn't you do? Get answers to these and other questions and get control of your vital messaging data. Download this free eBook today!
http://www.windowsitpro.com/go/ebooks/ilumin/discovery/?code=0402e&r

Are all your malware definitions completely up-to-date? If they are, then you're halfway home to total malware protection. Windows Vista might be the most secure Microsoft OS ever released, but malware is constantly evolving, and sometimes out-of-the-box security just isn't enough. In this exclusive podcast, Windows IT Pro Editorial and Strategy Director Karen Forster interviews Microsoft Product Manager Josue Fontanez about Forefront Client Security, Microsoft's unified malware protection package.
http://www.windowsitpro.com/go/podcast/coresecurity/forefrontclient/?code=0402e&r

==== Featured White Paper ====

How do compliance regulations really affect your IT infrastructure? You need to design your retention, retrieval, privacy, and security policies to ensure that your organization is compliant. Download this free eBook today and make certain that your organization complies with regulations!
http://www.windowsitpro.com/go/ebooks/sherpa/compliance/?code=0402featwp

===== Announcements ====

Introducing a Unique Security Resource Security Pro VIP is an online information center that delivers new articles every week on topics such as perimeter security, authentication, and system patches. Subscribers also receive tips, cautionary advice, direct access to our editors, and a host of other benefits! Order now at an exclusive charter rate and save up to $50! https://store.pentontech.com/index.cfm?s=1&promocode=eu2574us

Grab Your Share of the Spotlight! Nominate yourself or a peer to become IT Pro of the Month. This is your chance to get the recognition you deserve! Winners will receive over $600 in IT resources and be featured in Windows IT Pro. It's easy to enter--we're accepting May nominations now, but only for a limited time! Submit your nomination today: http://www.windowsitpro.com/go/itpromonth

====================

==== Contact Us ====

About the newsletter -- [email protected] About technical questions -- http://www.windowsitpro.com/forums About product news -- [email protected] About your subscription -- [email protected] About sponsoring UPDATE-- [email protected]

====================

This email newsletter is brought to you by Windows IT Pro, the leading publication for IT professionals deploying Windows and related technologies. Subscribe today.
https://store.pentontech.com/index.cfm?s=1&promocode=eu205xxb

Make sure your copy of Windows Tips & Tricks UPDATE isn't mistakenly blocked by antispam software! Be sure to add [email protected] to your list of allowed senders and contacts.

Manage Your Account You are subscribed as %%$email%%

You are receiving this email message because you subscribed to this newsletter on our Web site. To unsubscribe, click the unsubscribe link:

http://list.windowsitpro.com/u?id=%%SUBSCRIBER_ID_TAG%%

View the Windows IT Pro Privacy policy at http://www.windowsitpro.com/AboutUs/Index.cfm?action=privacy

Windows IT Pro, a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department

Copyright 2007, Penton Media, Inc. All Rights Reserved.