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

[cc lang=”sql”]
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
[/cc]

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

[cc lang=”sql”]
SELECT @@VERSION
[/cc]