Search This Blog

Saturday, February 22, 2014

How to determine MSSQL version and edition?

How to determine MS SQL version and edition?

  1. Go to Open Query Analyzer 
  2. Paste sql script below

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
  3. Click on Execute button

There you can see the version and edition for Microsoft SQL server installed in your computer.

No comments: