Reznix

Tech Support: What version of SQL are you running?
You: Ahh Jeez, let me check…

SQL Server RTM 2005.90.1399
SQL Server 2005 SP1 2005.90.2047
SQL Server 2005 SP2 2005.90.3042

SQL Server 2000 RTM 2000.80.194.0
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 2000 SP4 2000.8.00.2039

SQL Server 7.0 RTM 7.00.623
SQL Server 7.0 SP1 (SP1) 7.00.699
SQL Server 7.0 SP2 (SP2) 7.00.842
SQL Server 7.0 SP3 (SP3) 7.00.961
SQL Server 7.0 SP4 (SP4) 7.00.1063

and for you really sick folk:

SQL Server 6.5 RTM 6.50.201
SQL Server 6.5 SP1 6.50.213
SQL Server 6.5 SP2 6.50.240
SQL Server 6.5 SP3 6.50.258
SQL Server 6.5 SP4 6.50.281
SQL Server 6.5 SP5 6.50.415
SQL Server 6.5 SP5a 6.50.416
SQL Server 6.5 SP5a Update 6.50.479

Commands to get the numbers above:

SQL 2005

Use SQL Server Management Studio

SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)

SQL 2000

Use Query Analyzer

SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)

SQL 7

Use Query Analyzer

SELECT @@VERSION

SQL 6.5

Upgrade, you cheapskate

References:

support.microsoft.com/kb/321185

www.krell-software.com/mssql-builds.asp?version=90

www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx