The TechNet Wiki

April 25, 2010

The beta of the TechNet Wiki This is TechNet’s new home for community-generated content about Microsoft technologies, and you’re invited to jump in and edit or create your own page. For more on this community platform service, check out Keith Combs’ blog post.


Microsoft 2010 Beta downloads

November 21, 2009

Download Microsoft Office Professional Plus 2010 Beta…

Download Microsoft Visio Premium 2010 Beta…

Download Microsoft SharePoint Server 2010 Beta…

Welcome to the Microsoft SharePoint Server 2010 Beta Resource Center…

How to determine which version of SQL Server 2005 is running

July 27, 2009

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

  • The product version (for example, 9.00.1399.06)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise Edition)

For example, the results resemble the following.

 Collapse this table Expand this table
9.00.1399.06 RTM Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table
Release Sqlservr.exe
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042
SQL Server 2005 Service Pack 3 2005.90.4035

 Source (KB321185)…

Where do I get the installer for MSDE SP4?

June 25, 2009

Microsoft SQL Server Desktop Engine (MSDE) is a free version of Microsoft SQL Server that is suitable for logging data in smaller networks.

(Microsoft does not support installing MSDE on Windows Server 2008).

Language Link
Brazilian Portuguese
Simplified Chinese
Traditional Chinese

W2k8 + Vista SP2 (KB948465)

May 30, 2009

SP1 is a prerequisite for installing SP2. (W2k8 released with SP1 included. Vista SP1 information and downloads @ Windows Vista SP1 TechNet

W2k8SP2 and Vista SP2 – Five Language Standalone version can be installed on systems with any of the following language versions: English, French, German, Japanese, or Spanish.

If your system has additional languages use the All Language Standalone to install SP2.

Windows Server SP2/Windows Vista SP2 page on TechNet/MSDN for additional details and documentation.

SP2 info @
Windows Vista SP2 TechNet
Windows Server 2008 SP2 TechNet


Why NOT to activate Office immediately

May 30, 2009
  • Getting a product activation registers your use of Office on a particular computer – you should not do that until you’re sure you are happy with that computer.
  • Certain events e.g. new PC doesn’t work properly and has to be repaired or replaced, you decide to switch Windows versions (eg XP to Vista or vice-versa, can force you to reinstall Office yet again after a short time. Sure, you can call Microsoft and explain what happened but if you didn’t activate Office in the first place, the later install and activation is more likely to go through quickly.
  • You can use Office 2007 without product activation (or even a Product Key in many cases) for the first 25 times you start an Office program.
  • There is no risk that you’ll forget to activate Office later. There’s a prompt to activate when you start Office and after the ‘no activation’ limit Office goes into a ‘reduced functionality’ mode. Once you’ve activated Office returns to it’s full glory.

If you’re using a laptop, make sure Office is activated before you start travelling, especially if you might be disconnected from the Internet.

Delaying activation is quite possible and lets you ensure that the computer you’re using is a stable and suitable platform for Microsoft Office. Make use of that opportunity.


Using Office on netbook computers

May 29, 2009