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.