Find SQL Server Version and Edition Information

General 1 Minute

There are several ways to find out the sql server edition/version and service pack levels. Some of the common methods are

1. Select ServerProperty('ProductVersion'),ServerProperty('Edition'),
ServerProperty('ProductLevel')

2.Select @@Version

3.Open the SQL Server Error  Log file and you would find this information there.

4. Go to Run–>type ‘RegEdit’–> HKEY_LOCAL_MACHINE–>SOFTWARE–>MICROSOFT–>MICROSOFT SQL SERVER–>MSSQL10.50.MSSQLSERVER–> SET UP.

Methods 3  and 4 are useful when you cannot connect to sql server but you want to find Version/Edition details of your sql server.

http://www.SQLServerbuilds.blogspot.com is a very handy website when you want to find information on sql server builds, latest hotfixes and patches.

Advertisement

Published by SQLWhisperer

Hello Everyone. My intention of having this site is to have one repository location for my SQL Server Learning's. Most of the information here is already available on Web but I want to have it in one global location, so I can reference whenever I need . I would be more than happy, if you find anything on this blog useful. Also, Please use your own caution when running any code on your systems.Thank you for visiting.

Published