{"id":3488,"date":"2012-03-18T09:06:13","date_gmt":"2012-03-18T17:06:13","guid":{"rendered":"https:\/\/www.zubairalexander.com\/stage\/?p=3488"},"modified":"2012-03-19T09:21:42","modified_gmt":"2012-03-19T17:21:42","slug":"how-to-determine-the-version-and-edition-of-sql-server-and-its-components","status":"publish","type":"post","link":"https:\/\/www.zubairalexander.com\/blog\/how-to-determine-the-version-and-edition-of-sql-server-and-its-components\/","title":{"rendered":"How to Determine the Version and Edition of SQL Server and its Components"},"content":{"rendered":"<p>Microsoft has documented some useful information on how to determine your current Microsoft SQL  Server version number and the corresponding product or service pack  level in the <a href=\"http:\/\/support.microsoft.com\/kb\/321185\">KB article 321185<\/a>. The article also describes how to determine the specific edition of SQL  Server that you are using.<\/p>\n<p>There is another article that has information on how to find the latest builds for SQL Server. That information is available in the <a href=\"http:\/\/support.microsoft.com\/default.aspx?scid=kb;EN-US;957826\">KB article 957826<\/a>.<\/p>\n<p>For example, to determine the version number of the SQL Server Client tools in SQL Server 2008 R2 you can start the SQL Server Management Studio (SSMS) and go to Help, About.<\/p>\n<p><a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2012\/03\/sql_versions.png\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-3496\" title=\"sql_versions\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2012\/03\/sql_versions-236x300.png\" alt=\"\" width=\"236\" height=\"300\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2012\/03\/sql_versions-236x300.png 236w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2012\/03\/sql_versions.png 478w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/a><\/p>\n<p>It&#8217;s easy to verify that you have the latest build by using these KB articles. For example, Build 10.50.2806.0 (Cumulative update package) was the latest build as of today for SQL Server 2008 R2 since the release of SQL Server 2008 R2 Service Pack 1.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has documented some useful information on how to determine your current Microsoft SQL Server version number and the corresponding product or service pack level in the KB article 321185. The article also describes how to determine the specific edition of SQL Server that you are using. There is another article that has information on [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[59,11],"tags":[],"class_list":["post-3488","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-tips-tricks"],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/3488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/comments?post=3488"}],"version-history":[{"count":0,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/3488\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media?parent=3488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/categories?post=3488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/tags?post=3488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}