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.
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.
The following table lists the Sqlservr.exe version number.
|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|
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).
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.
- 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.