Features and Functionality in Windows XP Service Pack 2

Get detailed information about the changes to network protection, memory protection, enhanced browser security, and other technologies included in SP2.

Understand how to test for application compatibility with Windows XP SP2 and mitigate possible issues caused by its new security technologies.

The Cable Guy article for August 2004 describes the enhancements included in Windows XP SP2 to support Institute of Electrical and Electronic Engineers (IEEE) 802.11-based wireless local area networks (LANs).

The Cable Guy article for January 2004 describes the new networking features in Windows XP SP2 that provide enhanced security and additional functionality for wireless users and peer-to-peer network applications.

The Cable Guy article for June 2004 describes the new Wireless Network Setup Wizard, which allows users to easily configure strong security for wireless networks in the home or small office.

Review this FAQ to find answers to common questions about how Windows XP SP2 affects installations of SQL Server 2000 and SQL Server Desktop Engine (MSDE).

Review the Windows XP section of the SMS Client FAQ to find out how Microsoft Windows XP SP2 affects SMS client and SMS administration from a computer running XP SP2.

For network administrators.

For a single computer, you should use Microsoft Update.