{"id":673,"date":"2012-01-01T23:14:00","date_gmt":"2012-01-01T22:14:00","guid":{"rendered":"http:\/\/sburke.eu\/blog\/?p=673"},"modified":"2022-07-25T23:27:40","modified_gmt":"2022-07-25T22:27:40","slug":"find-all-mssql-instances-running-connect-and-show-version","status":"publish","type":"post","link":"http:\/\/sburke.eu\/blog\/2012\/01\/find-all-mssql-instances-running-connect-and-show-version\/","title":{"rendered":"Find all MSSQL Instances running, Connect and show Version"},"content":{"rendered":"\n<p>The diagram below, shows how you can use SQL Management Studio to connect to all instances of SQLServer running on your computer (as indicated in the Services list) and run a simple query to find out the exact version and service pack of SQLServer running.<\/p>\n\n\n\n<p>In the SQL Management Studio, you can connect to a default instance by just typing the computername. To connect to a named (second) instance, you can connect to&nbsp;<strong>computername\\instancename<\/strong><\/p>\n\n\n\n<p>Clicking &#8220;New Query&#8221; opens up the query window,&nbsp;and after typing&nbsp;&#8220;<strong>select @@version<\/strong>&#8221; (intellisense prompting will appear) and pressing F5, runs the query and shows the SQLServer version and service pack.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"1024\" height=\"877\" src=\"http:\/\/sburke.eu\/blog\/wp-content\/uploads\/2022\/07\/ms-sql-server-connect-instance-check-version-service-pack-1024x877.gif\" alt=\"\" class=\"wp-image-675\" title=\"ms-sql-server-connect-instance-check-version-service-pack\" srcset=\"http:\/\/sburke.eu\/blog\/wp-content\/uploads\/2022\/07\/ms-sql-server-connect-instance-check-version-service-pack-1024x877.gif 1024w, http:\/\/sburke.eu\/blog\/wp-content\/uploads\/2022\/07\/ms-sql-server-connect-instance-check-version-service-pack-300x257.gif 300w, http:\/\/sburke.eu\/blog\/wp-content\/uploads\/2022\/07\/ms-sql-server-connect-instance-check-version-service-pack-768x658.gif 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>The diagram below, shows how you can use SQL Management Studio to connect to all instances of SQLServer running on your computer (as indicated in the Services list) and run a simple query to find out the exact version and &hellip; <a href=\"http:\/\/sburke.eu\/blog\/2012\/01\/find-all-mssql-instances-running-connect-and-show-version\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[59],"_links":{"self":[{"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/posts\/673"}],"collection":[{"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/comments?post=673"}],"version-history":[{"count":2,"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/posts\/673\/revisions"}],"predecessor-version":[{"id":676,"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/posts\/673\/revisions\/676"}],"wp:attachment":[{"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/media?parent=673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/categories?post=673"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sburke.eu\/blog\/wp-json\/wp\/v2\/tags?post=673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}