How to find out your SQL Server version?




Here’s a quick trick the will allow you to easily retrieve information about the Microsoft SQL Server version that you are currently running. This quick how-to was written using SQL Server 2005, but it’s applicable to SQL Server 2000 as well.

  1. Login to the Microsoft SQL Server Management Studio (Query Analyzer in SQL Server 2000)
  2. Click New Query
  3. Type and Execute the following SQL command:

SELECT SERVERPROPERTY (’productlevel’) as ‘Product Level’, SERVERPROPERTY(’productversion’) as ‘Product Version’, SERVERPROPERTY (’edition’) as ‘SQL Server Edition’

A complete map of SQL Server product Level and Product Versions can be found at the bottom of this page.


Looking for quick tech support or for computer and social networks tutorials? Need info on iPods or cellular phones? Leave me a comment and have your question answered here at EasyTweaks.com!


Hope that you enjoy this web site. If possible, please make sure that you take our 2 minute long demographics survey. This will help us to keep the lights on. Thanks!



Filed Under How Tos 




Comments

Leave a Reply