Skip navigation
Find Your SQL Server Service Pack Level

Find Your SQL Server Service Pack Level

See how to find your server's SP level

Q: How can I tell what service pack level my SQL Server system has?

A: You can find your SQL Server system’s service pack level is a few different ways. First, you can use SQL Server SQL Server Management Studio. Object Explorer will show the version information in parentheses.

You can also run either of the following query using Query Analyzer:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The service pack level will be listed in the second column. Here you can see no service packs have been applied.

(No column name)          (No column name)          (No column name)

12.0.2254.0                    RTM                               Developer Edition (64-bit)

Alternatively, you also find the SQL Server service level information by opening the Errorlog file for that instance. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files. The build and service pack levels will be listed at the top of the file.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish