You can determine what version SQL Server is running by running
Select @@version
@@Version is a system level variable that holds the current version. On my computer this returns
SQL Server Versions
| @@Version | SQL Server Version | Released |
|---|---|---|
| 6.50.201 | SQL Server 6.5 RTM | |
| 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 | |
| 7.00.623 | SQL Server 7.0 / MSDE 1.0 RTM | |
| 7.00.699 | SQL Server 7.0 SP1 | July 1999 |
| 7.00.842 | SQL Server 7.0 SP2 | March 20th, 2000 |
| 7.00.961 | SQL Server 7.0 SP3 | December 15th, 2000 |
| 7.00.1063 | SQL Server 7.0 SP4 | |
| 8.00.194 | SQL Server 2000 RTM | |
| 8.00.384 | SQL Server 2000 SP1 | |
| 8.00.534 | SQL Server 2000 SP2 | November 30th, 2001 |
| 8.00.760 | SQL Server 2000 SP3 |
Analysis Services
You can determine the OLAP version by starting the OLAP Manager. Click on the Servers node in the tree view and click on About Microsoft SQL Server OLAP Services. The versions are listed below:
| Help About | SQL Server OLAP Services version |
|---|---|
| 7.0.1073 | SQL Server 7.0 OLAP RTM |
| 7.0.1295 | OLAP Services SP1 |
| 7.0.1458 | OLAP Services SP2 |
| 7.0.1508 | OLAP Services SP3 |
| 8.0.194 | SQL Server 2000 Analysis Services RTM |
| 8.0.382 | Analysis Services SP1 |
| 8.0.532 | Analysis Services SP2 |