I get this question over and over again….
How do I know what version and edition of SQL Server is on XXXXXXXX Server??
You can use the below script for Query Analyzer to determine this information.
You can also find this information in SQL Server Enterprise Manager by highlighting the server, right-mouse click to select properties and the 'General' Tab will have what you need.
Also see http://support.microsoft.com/default.aspx?scid=kb;en-us;321185.
SQL Server 2000: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
SQL Server 7.0: Select @@Version
Versions:
SQL Server 2000 Versions:
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 7.0 Versions:
7.00.1063 SQL Server 7.0 Service Pack 4 (SP4)
7.00.961 SQL Server 7.0 Service Pack 3 (SP3)
7.00.842 SQL Server 7.0 Service Pack 2 (SP2)
7.00.699 SQL Server 7.0 Service Pack 1 (SP1)
7.00.623 SQL Server 7.0 RTM (Release To Manufacturing)