To Identify your SQL Server Version

Some times, it is very hard for you to check your SQL Server version even log into the console as the about of SQL Server did not actually mentioned the actual version.

To get it done, you may run a query from the SQL Management where this is applied to SQL Server 2008, 2005 and 2000.

Open your SQL Server Management and enter the following query to the New Query file.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Result:

Published by

Mick Genie

Mick Genie is the founder of MickGenie.com and working at ExaBytes Network Sdn Bhd and WPWebHost web host company. He is expertise in Windows and Linux environment especially web hosting related information, tips and trick as well as the IT Information. View all posts by Mick Genie

Published by

Mick Genie

One thought on “To Identify your SQL Server Version”