| Author: Ashwini Rupert 20 Nov 2008 | Member Level: Diamond | Rating:  Points: 2 |
Hi,
Latest version of SQL Server is SQL Server 2008.
To identify the current version running on your machine
Select @@version
or you can pull the details from
exec master..xp_msver
What else you want to know about the sql server versions.
Regards,
Ashwini
|
| Author: Sriman N Vangala 21 Nov 2008 | Member Level: Diamond | Rating: Points: 3 |
various options to get the version of sql server are:
select @@version
or
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
or
exec master..xp_msver @name ='ProductVersion'
|
| Author: Sandesh S 21 Nov 2008 | Member Level: Gold | Rating: Points: 1 |
refer this
http://sanssql.blogspot.com/2008/06/which-command-using-query-analyzer-will.html
Regards,
Sandesh Segu
http://sanssql.blogspot.com
http://www.orkut.co.in/Main#Community?cmm=96088888
SansSQL
|
| Author: Legend 21 Nov 2008 | Member Level: Silver | Rating: Points: 5 |
Latest version of SQL Server is SQL Server 2008.
To identify the current version running on your machine
Select @@version
or you can pull the details from
exec master..xp_msver
or
http://sanssql.blogspot.com/2008/06/which-command-using-query-analyzer-will.html
or
select @@version
or
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
or
exec master..xp_msver @name ='ProductVersion'
|
| Author: sreeram 04 Dec 2008 | Member Level: Silver | Rating: Points: 2 |
Check the below link.here have the all the versions of the sqlserver informations is available.
http://www.krell-software.com/mssql-builds.asp
http://vyaskn.tripod.com/sqlsps.htm
|