{"id":732,"date":"2015-02-13T17:00:01","date_gmt":"2015-02-13T15:00:01","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=732"},"modified":"2015-02-13T17:00:01","modified_gmt":"2015-02-13T15:00:01","slug":"sql-server-adi-instance-name-degistirme","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-server-adi-instance-name-degistirme\/","title":{"rendered":"SQL Server ad\u0131 ( Instance Name ) de\u011fi\u015ftirme"},"content":{"rendered":"<p><span lang=\"EN\"><strong>SQL Server ad\u0131 ( Instance Name ) de\u011fi\u015ftirme<\/strong><\/p>\n<p><\/span><span lang=\"TR\">Bilgisayar\u0131n\u0131z\u0131n ad\u0131 de\u011fi\u015fti\u011fi zaman SQL Server &#8216;\u0131n ad\u0131 de\u011fi\u015fmeyecektir ve de\u011fi\u015fiklik \u00e7e\u015fitli sorunlara neden oalcakt\u0131r (\u00d6zellikle ismi de\u011fi\u015fen bilgisayar yada server\u0131n SQL ine d\u0131\u015fardan eri\u015fiyorsan\u0131z). Bu t\u00fcr bir sorunun \u00e7\u00f6z\u00fcm\u00fc SQL Server\u0131n\u0131z\u0131n ad\u0131n\u0131 da bilgisayar ad\u0131yla ayn\u0131 olacak \u015fekilde de\u011fi\u015ftirmektir. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki SP&#8217;leri kullanabilirsiniz:<\/span><\/p>\n<p>sp_dropserver &#8216;EskiServerAdi&#8217;<\/p>\n<p>sp_addserver &#8216;YeniServerAdi&#8217;, &#8216;local&#8217;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server ad\u0131 ( Instance Name ) de\u011fi\u015ftirme Bilgisayar\u0131n\u0131z\u0131n ad\u0131 de\u011fi\u015fti\u011fi zaman SQL Server &#8216;\u0131n ad\u0131 de\u011fi\u015fmeyecektir ve de\u011fi\u015fiklik \u00e7e\u015fitli sorunlara neden oalcakt\u0131r (\u00d6zellikle ismi de\u011fi\u015fen bilgisayar yada server\u0131n SQL ine d\u0131\u015fardan eri\u015fiyorsan\u0131z). Bu t\u00fcr bir sorunun \u00e7\u00f6z\u00fcm\u00fc SQL Server\u0131n\u0131z\u0131n ad\u0131n\u0131 da bilgisayar ad\u0131yla ayn\u0131 olacak \u015fekilde de\u011fi\u015ftirmektir. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki SP&#8217;leri kullanabilirsiniz: sp_dropserver [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-732","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=732"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/732\/revisions"}],"predecessor-version":[{"id":733,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/732\/revisions\/733"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}