{"id":1442,"date":"2012-07-05T20:01:10","date_gmt":"2012-07-06T01:01:10","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1442"},"modified":"2012-07-05T20:01:10","modified_gmt":"2012-07-06T01:01:10","slug":"sql-pretty-printer-works-when-multi-ssms-installed","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/","title":{"rendered":"SQL Pretty Printer works when Multi-SSMS installed"},"content":{"rendered":"<p>This is a feedback from one of our users:<\/p>\n<blockquote><p>I am (was) running SSMS versions 9.0 and 11.0 (11.0.2100.60).  Both are are the &#8220;Express&#8221; versions of MSSQL.  The menu only appeared in 9.0.<\/p>\n<p>I uninstalled the 9.0 instance, and then the Pretty Printer started showing up in the 11.0 SSMS.  So it is possibly related to having multiple versions of SSMS installed at once.<\/p>\n<p>It&#8217;s not a big deal at this point &#8211; I&#8217;m just removing 9.0 all together because I don&#8217;t really need it.<\/p>\n<p>Thanks for the support!<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>This is a feedback from one of our users: I am (was) running SSMS versions 9.0 and 11.0 (11.0.2100.60). Both are are the &#8220;Express&#8221; versions of MSSQL. The menu only appeared in 9.0. I uninstalled the 9.0 instance, and then the Pretty Printer started showing up in the 11.0 SSMS. So it is possibly related to having multiple versions of SSMS installed at once. It&#8217;s not a big deal at this point &#8211; I&#8217;m just removing 9.0 all together because I don&#8217;t really need it. Thanks for the support!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[24],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Pretty Printer works when Multi-SSMS installed<\/title>\n<meta name=\"description\" content=\"SQL Pretty Printer works when Multi-SSMS installed\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Pretty Printer works when Multi-SSMS installed\" \/>\n<meta property=\"og:description\" content=\"SQL Pretty Printer works when Multi-SSMS installed\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-06T01:01:10+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\",\"name\":\"SQL Pretty Printer works when Multi-SSMS installed\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2012-07-06T01:01:10+00:00\",\"dateModified\":\"2012-07-06T01:01:10+00:00\",\"description\":\"SQL Pretty Printer works when Multi-SSMS installed\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Pretty Printer works when Multi-SSMS installed\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"SQL Pretty Printer works when Multi-SSMS installed\",\"datePublished\":\"2012-07-06T01:01:10+00:00\",\"dateModified\":\"2012-07-06T01:01:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/\"},\"wordCount\":89,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"sql pretty printer\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Pretty Printer works when Multi-SSMS installed","description":"SQL Pretty Printer works when Multi-SSMS installed","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/","og_locale":"en_US","og_type":"article","og_title":"SQL Pretty Printer works when Multi-SSMS installed","og_description":"SQL Pretty Printer works when Multi-SSMS installed","og_url":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/","og_site_name":"SQL and Data Blog","article_published_time":"2012-07-06T01:01:10+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/","url":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/","name":"SQL Pretty Printer works when Multi-SSMS installed","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2012-07-06T01:01:10+00:00","dateModified":"2012-07-06T01:01:10+00:00","description":"SQL Pretty Printer works when Multi-SSMS installed","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Pretty Printer works when Multi-SSMS installed"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"SQL Pretty Printer works when Multi-SSMS installed","datePublished":"2012-07-06T01:01:10+00:00","dateModified":"2012-07-06T01:01:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/sql-pretty-printer-works-when-multi-ssms-installed\/"},"wordCount":89,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["sql pretty printer"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.dpriver.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1442"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=1442"}],"version-history":[{"count":2,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1442\/revisions"}],"predecessor-version":[{"id":1444,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1442\/revisions\/1444"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}