How do I find out the version of SQL server that is running?

[630111]

Sorry for the newbie question.

I've been tasked with inventorying the datacenter, and need to find out the quickest way to find out what version of SQL server is running on each machine (if it is at all).

Thanks, in advance!

630111

 

[sunila7]

hi,

u can find this out from query analyser, by running this statement

Select @@version

sunil

 

[Gauss]

Hello!

The following might be useful (after select @@version):

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
8.00.194 SQL Server 2000 RTM
8.00.384 SQL Server 2000 SP1
8.00.534 SQL Server 2000 SP2 November 30th, 2001