{"id":5411,"date":"2018-11-15T06:22:15","date_gmt":"2018-11-15T06:22:15","guid":{"rendered":"https:\/\/dbtut.com\/?p=5411"},"modified":"2019-05-19T22:36:15","modified_gmt":"2019-05-19T22:36:15","slug":"how-to-change-sql-instance-server-name-ans-servername-function","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/","title":{"rendered":"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function"},"content":{"rendered":"<p>Sometimes the name of the server changes and the SQL Server instance name must change accordingly.<\/p>\n<p>For example, suppose your server name is a test and you have an instance named testinstance on your test server.<\/p>\n<p>You can normally connect to Instance as &#8220;test\\testinstance&#8221;.<\/p>\n<p>Suppose that the name of the test server is changed to &#8220;prod&#8221;.<\/p>\n<p>If you want to query the name of instance with the command <code>Select @@SERVERNAME<\/code>, you will see that your instance name is still &#8220;test\\testinstance&#8221;.<\/p>\n<p>We can fix this with the code below.<\/p>\n<pre class=\"lang:default decode:true\">sp_dropserver 'test\\testinstance';\nGO\nsp_addserver 'prod\\testinstance', local;\nGO<\/pre>\n<p>If you are using SQL Server 2012 or newer version, you will receive the below error when you execute the above script. Because sp_addserver is no longer supported in SQL Server 2012 and newer versions.<\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 15663, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 60 [Batch Start Line 0] <\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Feature &#8220;sp_addserver&#8221; is no longer supported. Replace remote servers by using linked servers. <\/em><\/span><\/p>\n<p>To solve the error, use sp_addlinkedserver instead of sp_addserver.<\/p>\n<pre class=\"lang:default decode:true  \">sp_addlinkedserver 'prod\\testinstance', local<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5411\" class=\"pvc_stats all  \" data-element-id=\"5411\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test and you have an instance named testinstance on your test server. You can normally connect to Instance as &#8220;test\\testinstance&#8221;. Suppose that the name of the test server is changed to &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5411\" class=\"pvc_stats all  \" data-element-id=\"5411\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":12342,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[1883,4481,4486,4487,4483,4482,4489,4478,4493,4494,4490,4492,4499,4500,4501,4502,4497,4498,4503,4491,4488,4484,4485,4480,4479,4495,4496,4504],"class_list":["post-5411","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-servername","tag-can-we-change-instance-name-in-sql-server","tag-change-sql-server-instance-name-2012","tag-change-sql-server-instance-name-2014","tag-change-sql-server-instance-name-2016","tag-change-sql-server-instance-name-2017","tag-change-sql-server-instance-name-to-default","tag-feature-sp_addserver-is-no-longer-supported-replace-remote-servers-by-using-linked-servers","tag-how-to-change-server-name-in-sql-server-2012","tag-how-to-change-server-name-in-sql-server-2014","tag-how-to-change-server-name-in-sql-server-2016","tag-how-to-change-server-name-in-sql-server-2017","tag-how-to-find-instance-name-in-sql-server-2012","tag-how-to-find-instance-name-in-sql-server-2016","tag-how-to-find-instance-name-in-sql-server-2017","tag-how-to-find-instance-name-in-sql-server-management-studio","tag-how-to-find-sql-server-instance-name-from-cmd","tag-how-to-find-sql-server-instance-name-on-local-machine","tag-how-to-find-sql-server-name-in-windows-10","tag-rename-sql-server-instance-2012","tag-rename-sql-server-instance-2014","tag-rename-sql-server-instance-2016","tag-rename-sql-server-instance-2017","tag-sp_addserver","tag-sp_dropserver","tag-sql-server-change-default-instance-to-named-instance","tag-sql-server-computer-name","tag-what-is-my-sql-server-name"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Change SQL Instance\/Server Name\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Change SQL Instance\/Server Name\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-15T06:22:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-19T22:36:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"647\" \/>\n\t<meta property=\"og:image:height\" content=\"363\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function\",\"datePublished\":\"2018-11-15T06:22:15+00:00\",\"dateModified\":\"2019-05-19T22:36:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\"},\"wordCount\":171,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png\",\"keywords\":[\"@@SERVERNAME\",\"Can we change instance name in SQL Server?\",\"change sql server instance name 2012\",\"change sql server instance name 2014\",\"change sql server instance name 2016\",\"change sql server instance name 2017\",\"change sql server instance name to default\",\"Feature \\\"sp_addserver\\\" is no longer supported. Replace remote servers by using linked servers.\",\"how to change server name in sql server 2012\",\"how to change server name in sql server 2014\",\"how to change server name in sql server 2016\",\"how to change server name in sql server 2017\",\"how to find instance name in sql server 2012\",\"how to find instance name in sql server 2016\",\"how to find instance name in sql server 2017\",\"how to find instance name in sql server management studio\",\"how to find sql server instance name from cmd\",\"how to find sql server instance name on local machine\",\"how to find sql server name in windows 10\",\"rename sql server instance 2012\",\"rename sql server instance 2014\",\"rename sql server instance 2016\",\"rename sql server instance 2017\",\"sp_addserver\",\"sp_dropserver\",\"sql server change default instance to named instance\",\"sql server computer name\",\"what is my sql server name\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\",\"name\":\"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png\",\"datePublished\":\"2018-11-15T06:22:15+00:00\",\"dateModified\":\"2019-05-19T22:36:15+00:00\",\"description\":\"How To Change SQL Instance\/Server Name\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png\",\"width\":647,\"height\":363},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function - Database Tutorials","description":"How To Change SQL Instance\/Server Name","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:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/","og_locale":"en_US","og_type":"article","og_title":"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function - Database Tutorials","og_description":"How To Change SQL Instance\/Server Name","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-15T06:22:15+00:00","article_modified_time":"2019-05-19T22:36:15+00:00","og_image":[{"width":647,"height":363,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function","datePublished":"2018-11-15T06:22:15+00:00","dateModified":"2019-05-19T22:36:15+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/"},"wordCount":171,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png","keywords":["@@SERVERNAME","Can we change instance name in SQL Server?","change sql server instance name 2012","change sql server instance name 2014","change sql server instance name 2016","change sql server instance name 2017","change sql server instance name to default","Feature \"sp_addserver\" is no longer supported. Replace remote servers by using linked servers.","how to change server name in sql server 2012","how to change server name in sql server 2014","how to change server name in sql server 2016","how to change server name in sql server 2017","how to find instance name in sql server 2012","how to find instance name in sql server 2016","how to find instance name in sql server 2017","how to find instance name in sql server management studio","how to find sql server instance name from cmd","how to find sql server instance name on local machine","how to find sql server name in windows 10","rename sql server instance 2012","rename sql server instance 2014","rename sql server instance 2016","rename sql server instance 2017","sp_addserver","sp_dropserver","sql server change default instance to named instance","sql server computer name","what is my sql server name"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/","name":"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png","datePublished":"2018-11-15T06:22:15+00:00","dateModified":"2019-05-19T22:36:15+00:00","description":"How To Change SQL Instance\/Server Name","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/Ads\u0131z-2.png","width":647,"height":363},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/15\/how-to-change-sql-instance-server-name-ans-servername-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Change SQL Instance\/Server Name ANS @@SERVERNAME Function"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=5411"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5411\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12342"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=5411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=5411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=5411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}