| Author: Ashwini Rupert 20 Nov 2008 | Member Level: Diamond | Rating:  Points: 3 |
Hi,
To identify the current version running on your machine
Select @@version
or you can pull the details from
exec master..xp_msver
Regards,
Ashwini
|
| Author: DotNetJaps 20 Nov 2008 | Member Level: Gold | Rating: Points: 3 |
there are lots of version sql sever
sql server 6.0
sql server 2000
sql server 2005
etc.
and in all the version you have sub version like
enterprise edition
workgroup edition
professional edition
etc.
|
| Author: Sriman N Vangala 21 Nov 2008 | Member Level: Diamond | Rating: Points: 6 |
Here the details of the versions:
Version Year Release Name Codename
--------------------------------------------------------------------
1.0(OS/2) 1989 SQL Server 1.0 -
4.21(WinNT) 1993 SQL Server 4.21 -
6.0 1995 SQL Server 6.0 SQL95
6.5 1996 SQL Server 6.5 Hydra
7.0 1998 SQL Server 7.0 Sphinx
- 1999 SQL Server 7.0 OLAP Tools Plato
8.0 2000 SQL Server 2000 Shiloh
8.0 2003 SQL Server 200064-bit Edition Liberty
9.0 2005 SQL Server 2005 Yukon
10.0 2008 SQL Server 2008 Katmai
Pls chk the link for further info:
http://en.wikipedia.org/wiki/Microsoft_SQL_Server
|
| Author: Sandesh S 21 Nov 2008 | Member Level: Gold | Rating: Points: 2 |
PLease go to the below link
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 |
Version Year Release Name Codename
--------------------------------------------------------------------
1.0(OS/2) 1989 SQL Server 1.0 -
4.21(WinNT) 1993 SQL Server 4.21 -
6.0 1995 SQL Server 6.0 SQL95
6.5 1996 SQL Server 6.5 Hydra
7.0 1998 SQL Server 7.0 Sphinx
- 1999 SQL Server 7.0 OLAP Tools Plato
8.0 2000 SQL Server 2000 Shiloh
8.0 2003 SQL Server 200064-bit Edition Liberty
9.0 2005 SQL Server 2005 Yukon
10.0 2008 SQL Server 2008 Katmai
Pls chk the link for further info:
http://en.wikipedia.org/wiki/Microsoft_SQL_Server
|