Check for MSDE or SQL server Version

How to Check for MSDE or SQL Server Version

To determine if you have MSDE or Microsoft SQL Server installed on your computer:

1.	On the taskbar at the bottom of your screen, click Start, and then click Search.
2.	In the Search dialog box, type sqlservr.exe
3.	Click OK. If this file is present on your system, then you have MSDE or SQL Server installed.

To check current SQL Server service pack, open ISQLW (Query Analyzer) or ISQL or OSQL. Execute the following command:

SELECT @@VERSION
GO

The following are the available SQL versions

8.00.194 - SQL Server 2000 release

8.00.384 - SQL Server 2000 SP1

8.00.534 - SQL Server 2000 SP2

8.00.760 - SQL Server 2000 SP3

7.00.623 - SQL Server 7.0 release

7.00.699 - SQL Server 7.0 SP1

7.00.842 - SQL Server 7.0 SP2

7.00.961 - SQL Server 7.0 SP3

7.00.1063 - SQL Server 7.0 SP4

6.50.201 - SQL Server 6.5 release.

6.50.213 - SQL Server 6.5 with Service Pack 1

6.50.240 - SQL Server 6.5 with Service Pack 2

6.50.258 - SQL Server 6.5 with Service Pack 3

6.50.281 - SQL Server 6.5 with Service Pack 4

6.50.415 - SQL Server 6.5 with Service Pack 5

6.50.416 - SQL Server 6.5 with Service Pack 5a

Release Product version
SQL Server 2005 Service Pack 4 9.00.5000.00
SQL Server 2005 Service Pack 3 9.00.4035
SQL Server 2005 Service Pack 2 9.00.3042
SQL Server 2005 Service Pack 1 9.00.2047
SQL Server 2005 RTM 9.00.1399

Release Product version
SQL Server 2008 Service Pack 3 10.00.5500.00
SQL Server 2008 Service Pack 2 10.00.4000.00
SQL Server 2008 Service Pack 1 10.00.2531.00
SQL Server 2008 RTM 10.00.1600.22

Post your questions, comments, feedbacks and suggestions

Contact a consultant