Share via

How do I find what SP level is installed in SQL 2012

Bob Dodson 20 Reputation points
2024-12-16T14:50:26.24+00:00

I need to find what service pack SQL 2012 is at I have a software update that requires SP4

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
0 comments
Accepted answer
  1. Andrew Tabar 271 Reputation points
    2024-12-16T15:20:08.7166667+00:00

    Start SQL Management Studio and run this query:

    SELECT @@VERSION

    You'll get back the SQL version and you can look on this table to see what version/SP is installed:

    https://sqlserverbuilds.blogspot.com/2012/01/sql-server-2012-versions.html

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andrew Tabar 271 Reputation points
    2024-12-16T15:21:14.44+00:00

    Start SQL Management Studio and run this query:

    SELECT @@VERSION

    You'll get back a version number and you can look on this table to see what SP and hotfixes are installed:

    https://sqlserverbuilds.blogspot.com/2012/01/sql-server-2012-versions.html

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.