SQL Server 2005 Service Pack, Version, Edition

Here is how I find out what SQL Server 2005 DB I am playing with:

  1. Log into any DB in your SS 2005 instance
  2. Run the following query
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Leave a Reply

Your email address will not be published. Required fields are marked *