How To Know the Version of SQL Server
Being as a techie i have worked on almost all SQL Server Management Studios, there are different kind of SQL Server versions and Editions are there in the market, today we will see how to know the version of SQL Server. It doesn’t matter if it’s a SQL Server 2000, SQL Server 2005 or SQL Server 2008.
This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to identify the specific edition of SQL Server you are using.
How To Know the Version of SQL Server 2008
To determine which version of Microsoft SQL Server 2008 is running, connect to SQL Server 2008 by using SQL Server Management Studio, and then run the following Transact-SQL(Query) statement.
SELECT SERVERPROPERTY(‘productversion‘), SERVERPROPERTY (‘productlevel‘), SERVERPROPERTY (‘edition‘)
The following results are returned:
- The product version (for example, 10.0.1600.22)
- The product level (for example, RTM)
- The edition (for example, Enterprise)
Note: You can use same query to know the version of SQL Server 2000 and SQL Server 2005 also.
Visit – http://support.microsoft.com/kb/321185 for more information.
