{"id":111,"date":"2015-05-07T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/blog\/multiple-server-management-finding-the-database-server"},"modified":"2026-03-18T21:51:46","modified_gmt":"2026-03-18T21:51:46","slug":"multiple-server-management-finding-the-database-server","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2015\/05\/07\/multiple-server-management-finding-the-database-server\/","title":{"rendered":"Multiple Server Management &#8211; Finding the Database Server"},"content":{"rendered":"<p>Often database administrators must ask themselves a simple, yet tedious question, \u201cwhat server is that database on,\u201d or maybe, \u201chow many servers do we still have on SQL Server 2005?\u201d This article will cover how to use SQL Server\u2019s Central Management Server to manage your server list and it will demonstrate how to use T-SQL and\/or PowerShell to quickly search for the subset of servers that you need in the moment.<\/p>\n<h2>Read more<\/h2>\n<p><a href=\"http:\/\/www.sqlshack.com\/multiple-server-management-finding-the-database-server\/\">SQLShack.com \u2013 Multiple Server Mangement \u2013 Finding the Database Server<\/a><\/p>\n<h2>Download the scripts<\/h2>\n<p><a href=\"http:\/\/www.sqlhammer.com\/blog\/wp-content\/uploads\/2015\/05\/import-servers-into-cms.txt\">Import server list into CMS (PowerShell)<\/a><\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/blog\/wp-content\/uploads\/2015\/05\/Search-CMS.txt\">Search-CMS (PowerShell)<\/a><\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/blog\/wp-content\/uploads\/2015\/05\/get-reg-servers-from-CMS.txt\">Query registered servers from CMS (T-SQL)<\/a><\/p>\n<hr \/>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/hammer-derik-172x140.png\" alt=\"\" \/><strong>Written by Derik Hammer of <a href=\"http:\/\/www.sqlhammer.com\/\">SQL Hammer<\/a><\/strong><\/p>\n<p>Derik is a data professional focusing on Microsoft SQL Server. His passion focuses around <a href=\"http:\/\/www.sqlhammer.com\/blog\/category\/high-availability\/\">high-availability<\/a>, <a href=\"http:\/\/www.sqlhammer.com\/blog\/category\/general\/disaster-recovery\/\">disaster recovery<\/a>, continuous integration, and automated maintenance. his experience has spanned long-term database administration, consulting, and\u00a0entrepreneurial ventures.<\/p>\n<p>Derik gives the SQL community credit for plugging the gaps in his knowledge when he was a junior DBA and, now that his skills have matured, started <a href=\"http:\/\/www.sqlhammer.com\/\">SQLHammer.com<\/a> as one small way to give back and continue the cycle of shared learning.<\/p>\n<p>Derik is the owner and lead author of SQL Hammer, a <a href=\"http:\/\/www.sqlhammer.com\/\">Microsoft SQL Server resource<\/a>.<\/p>\n<p>For more information, visit <a href=\"http:\/\/www.sqlhammer.com\/\">http:\/\/www.sqlhammer.com<\/a>. Follow Derik on <a href=\"http:\/\/twitter.com\/SQLHammer\">Twitter<\/a> for <strong>SQL tips and chat<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often database administrators must ask themselves a simple, yet tedious question, \u201cwhat server is that database on,\u201d or maybe, \u201chow many servers do we still have on SQL Server 2005?\u201d This article will cover how to use SQL Server\u2019s Central Management Server to manage your server list and it will demonstrate how to use T-SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-111","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=111"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/111\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/111\/revisions\/373"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media\/530"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}