Check for MSDE or SQL server

Home | Troubleshooting |

Clearapps network inventory
software.

How to Check for MSDE or SQL Server

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