How to identify which version of SQL Server 7.0 is running?

To identify which version of Microsoft SQL Server 7.0 is running, connect to SQL Server 7.0 by using Query Analyzer, and run the following T-SQL statement.

SELECT @@VERSION

Above query will return resulset like

Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.1 (Build 2600: )

Following table shows SQL Server 7.0 releases.

Release Version
RTM 7.00.623
SQL Server 7.0 SP1 7.00.699
SQL Server 7.0 SP2 7.00.842
SQL Server 7.0 SP3 7.00.961
SQL Server 7.0 SP4 7.00.1063

Category

Recent Posts

Tag cloud