Identify SQL Server Version and Edition

To identify the version number and the corresponding product or service pack level SQL server run, use below Transact-SQL statement.
select serverproperty('productversion') as Version, serverproperty('productlevel') as level,serverproperty('edition') as edition
where
SERVERPROPERTY() is a function of SQL Server to extract information such as edition of sql server, licence type, collation type, machine name, server name etc etc..
select  @@version as WindowsOS --for windows version
Returns U the Service pack level for SQL.
Note that the Service Pack reported in the version string is the OS service pack level.
We can use both the queries are ok  check at below link
http://support.microsoft.com/kb/321185

ABOVE APPLIES TO
Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 2000 64-bit Edition
Microsoft SQL Server 7.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Workgroup Edition
Microsoft SQL Server 2008 Developer
Microsoft SQL Server 2008 Enterprise
Microsoft SQL Server 2008 Standard
Microsoft SQL Server 2008 Web
Microsoft SQL Server 2008 Workgroup
Microsoft SQL Server 2008 Express

1 comments:

There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users.

Post a Comment