<p>How can I find out which Service Pack is installed on my copy of SQL Server?</p>

[{'answer_id': 31820, 'author': 'Sergio Acosta', 'author_id': 2954, 'author_profile': 'https://Stackoverflow.com/users/2954', 'pm_score': 5, 'selected': True, 'text': '<p>From TechNet: <a href="https://gallery.technet.microsoft.com/Determining-which-version-af0f16f6" rel="noreferrer">Determining which version and edition of SQL Server Database Engine is running</a></p>\n\n<pre><code>-- SQL Server 2000/2005\nSELECT  SERVERPROPERTY(\'productversion\'), SERVERPROPERTY (\'productlevel\'), SERVERPROPERTY (\'edition\')\n\n-- SQL Server 6.5/7.0\nSELECT @@VERSION\n</code></pre>\n'}, {'answer_id': 9741878, 'author': 'Amarnath', 'author_id': 967638, 'author_profile': 'https://Stackoverflow.com/users/967638', 'pm_score': 3, 'selected': False, 'text': '<pre><code>Select @@Version\n</code></pre>\n\n<blockquote>\n  <p>Ex: My machine has the following one installed.</p>\n  \n  <p>Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2\n  2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition\n  on Windows NT 6.1 (Build 7601: Service Pack 1)</p>\n</blockquote>\n'}]
['https://Stackoverflow.com/questions/31818', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/3353/']