Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to verify the version of SQL Server?

April 26, 2017SQL Server verify version

0

Posted

How to verify the version of SQL Server?

1 Answer

0

Posted

There are a few ways to verify the version of SQL Server. Method 1. You can run a query “SELECT @@VERSION” and note the version number returned in the string. SQL Server 2005 SP1 would return something like the following: Microsoft SQL Server 2005 – 9.00.2047.00 (Intel X86) Sep 22 2006 23:44:32 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Method 2. you can also look at the file version for sqlservr.exe. Method 3. If you look in Add\Remove Programs, you would also see an entry for Service Pack 1 for SQL Server . Each patched component would have its own entry. Please note that you will need to select the “Show Updates” check box in the Add\Remove Programs dialog. Method 4. You can check the registry keys and values under: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server There are several other areas that contain version information. Shared components generally have a Setup sub-key under “HKEY_LO