What Version of SQL Server Am I Running?

The following shows how to find the version of SQL Server you are running (described as productversion). It also shows how to query the level of the product. The level of the product indicates whether it was the initial release, a service pack, or a beta version:

  1. RTM = shipping version
  2. SPn = service pack (where n is the version)
  3. CTP = Community Technology Preview version
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

If the above statement does not work, you may be running SQL Server 7.0. In which case, use the following statement:

SELECT @@VERSION

Featured Articles

 Site Author

  • Thanks for visiting!