How to know the details of your SQL Server

Once or a while many of  the people really get confused with the edition of SQL Server,A very good example is as Below Answer is very simple run xp_msver in the SSMS  .check the output below xp_msver gives the complete information about the SQL Server . Option 2 run this query SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), […]

SQL Server Edition List

SQL Server Version List is as below SQL Server 2012 will available in Market After 23 March 2012 SQL Server 2012 Denali CTP(Community technology preview) 11.00.1103.9 CTP3 11.00.1440.19 CTP 11.00.1750.30 SQL Server  2008 R2 RTM 10.5.1600.1 SP1 10.50.2500.1 SQL Server  2008Katmai/Akadia RTM 10.0.1600.22 SP1 10.0.2531.00 SP2 10.0.4000.00 SP3 10.0.5500.00 SQL Server  2005Yukon RTM 9.0.1399 SP1 9.0.2047 […]