Facebook RSS X

[TIPS] – SQL Server: how to rename the @@SERVERNAME of your SQL instance

Par
JL
-
23
292

Little “tips” to end the day, we will see how to rename the variable @@SERVERNAME of your SQL instance. If like me, once your SQL Server deployed, optimized as it should and ready to do battle with your developers, you notice that the server name does not match the “naming Charter” business…

You have two choices, first you can decide to format everything and start from scratch, or you can change the names properly 🙂

Yes, it is possible to rename it once SQL Server installed :

  1. Out the AD server
  2. Rename the server
  3. Integrate the server with your AD
  4. Follow the procedure below for SQL

Since SSMS, run the following query to check the value of @@SERVERNAME:

SELECT @@SERVERNAME AS 'Server Name';

Then enter the following commands:

sp_dropserver<OLD_SERVERNAME></OLD_SERVERNAME>
GO
sp_addserver <NEW_SERVERNAME>, local;</NEW_SERVERNAME>
GO

 

Restart the SQL  instance from SSMS (right click on the instance and then restart) and control by typing the first command again.

If all goes well your SQL instance has now the good server name.

Tweet
Pin
Share
0 Shares
JL
JL
https://sys-advisor.com
Fondateur de sys-Advisor.com, Passionné avant tout, je partage mon quotidien à travers ce site. #sysadmin #microsoft #vmware #tech #geek @sysadvisor

23 Commentaires

  8. Hi! This post could not be written any better! Reading through this post reminds me of my good old room mate!
    He always kept chatting about this. I will forward this
    article to him. Pretty sure he will have a good read.
    Many thanks for sharing!

  18. You may not move your checkers onto a Point with two or more opponent checkers.

    You may move your checkers onto any Point so long as it
    is occupied by your checkers, is empty, or has 1 opponent checker.
    The numbers on the dice refer to how many spaces you may move with
    one or more checkers. The gameplay on 247 Backgammon is seamless
    and you’ll quickly become addicted to the beautiful artwork and perfect
    puzzle game. This backgammon site even remembers your preferences
    every time you come back so you’ll be set to
    play immediately! 247 Backgammon offers the best backgammon game online.

    Sorry, you were disconnected from the game for too long, we had to
    remove you from the game so the others could keep playing.
    If you’re looking for a way to pass the time, sharpen your
    cognitive abilities, or simply have some fun,
    you should consider playing Backgammon today.
    Failing to knock your opponent’s checkers off the board.
    Being aware of the common mistakes that beginners make when playing backgammon makes it easier to avoid similar pitfalls yourself, improving your scores and chances of winning.

    While part of the gameplay is based on luck (the numbers appearing on the dice), strategy
    is also key to success. However, you could also learn by watching other,
    more experienced players.
    The objective of backgammon is to move all your
    checkers into your home board and then remove them from the board completely before your opponent does.
    This is a game of logic that allows you to play the classic and ancient board game of backgammon against other players worldwide.
    Backgammon Online is a casual game adapted from the original board game for online players.
    At any time during gameplay a player may before his/her turn propose the game be
    played for twice the current stake (beginning at 2).

    References:
    https://blackcoin.co/5_types-of-casino-bonuses-in-new_zealand_rewrite_1/

  19. Slot fans are certainly the most significant segment
    of online gamers who really pay a lot of money on gambling.
    Countless number of players are fond of online slots by uncomplicated gaming which usually is not
    going to demand any sort of practice nor methods. Only to make inexperienced online gamblers a bit more aware of the process of participating in casino online Australia,
    it is necessary to point out some of the most significant parts of the activity.
    Welcome to Australianvu.com, your ultimate destination for exceptional online casino action!
    Our Service may contain links to other sites that are not operated by us.
    We collect information that your browser sends whenever you visit
    our Service (“Log Data”). Our specialists start by examining the certificate and also their experience, to make
    sure that those who follow our guidance are actually protected.
    Experience the forefront of slot entertainment, access exclusive rewards, and spin your
    way to major triumphs. At Australianvu.com, we are dedicated to
    enhancing your gameplay with unparalleled promotions and bonuses
    designed to boost your wins.
    The first step assumes to get an account at a qualified
    online casino at which all of your games will be obtainable.
    If you have got a good knowledge of casinos online Australia, that’s the moment to order
    the real money type. Due to all of our reviews being unquestionably
    clear, players will find immediately the things you take
    and can easily make a commonsense choice on Australian casinos online and if you
    wish to join under the offered conditions. Those casinos online Australia
    all of us support are always accessible on cell phones and besides some of them often provoke gamblers to utilize smartphones
    and tablets granting additional bonuses and exceptional promotions.

    References:
    https://blackcoin.co/popular-variations-of-casino-slots-game-rules-and-descriptions/

  20. Whether you’re a slots enthusiast, table game strategist,
    or live dealer fan, Ripper Casino offers a secure, fair, and
    exciting environment with generous promotions, lightning-fast payouts, and dedicated customer support available 24/7.

    Our cutting-edge platform delivers premium entertainment with thousands of games from the world’s top providers.
    Registration takes minutes, welcome bonuses amplify your starting balance, and our
    library of 2,500+ games provides endless exploration possibilities.

    Ripper Casino withdrawal speeds depend on the
    method you choose. It’s a great way to test the waters
    before making a real deposit. Ripper Casino AU
    is committed to maintaining fairness and transparency
    across its platform. Yes – the fairness of every game
    is guaranteed. Once you’ve completed the registration process,
    you’re all set to start playing. This means you can play on the
    go without needing to download or install an app.
    If you’re feeling fancy, you can even use cryptocurrencies like Bitcoin, Litecoin, or
    Ethereum to make deposits! The casino’s elite mobile functionality ensures seamless navigation and fast loading times,
    making it an ideal destination for players on-the-go.

    Ripper Casino strives to process all withdrawals as quickly as possible, ensuring players receive their funds without unnecessary delays.

    References:
    https://blackcoin.co/rooli-casino-in-depth-review/

  21. Our ranking of the top AU casino sites goes beyond the basic criteria.
    When you register a new Australian casino
    online account, you get a 100% match up to A$750 with 200 free spins.
    MrPacho is one of the fastest withdrawal casino sites, allowing you
    to manage your finances with over a dozen banking methods.

    It is fully optimized for both Android and iOS
    smartphones and tablets, delivering a comfortable experience with no limitations.
    The site welcomes you with up to A$8,000 in bonus cash and 400 free spins across your first
    four deposits. Check out our recommended list of
    casinos, pick the one you like the most, and let the good times roll!

    We compiled a few tips for playing games at Australian casino sites
    from some of our long-time experts and gambling
    enthusiasts. First-tier online casinos in Australia won’t keep you
    waiting too long to deliver your payout, regardless of how you withdraw.
    Jackpot prizes are separate cash pools created by players playing select casino games (pokies, table games, or
    any game), known as progressive jackpots. The pokie review stage takes most
    of the time, often days, sometimes weeks, to review because of the sheer number of pokies at Australian online casinos.

  22. Neben der Stadt Frankfurt am Main unterliegt auch Wiesbaden bei
    der Kommunalaufsicht nach der Hessischen Gemeindeordnung unmittelbar dem Hessischen Innenministerium, die sonst vom Regierungspräsidium wahrgenommen wird.
    Der Magistrat als ausführendes Organ besorgt die laufende Verwaltung
    der Stadt und besteht aus dreizehn ehrenamtlichen und bis zu
    sechs hauptamtlichen Stadträten sowie dem Oberbürgermeister als dem Vorsitzenden und dem Bürgermeister
    als seinem Vertreter. Der Verwaltungsaufbau der Landeshauptstadt Wiesbaden richtet sich nach der
    Hessischen Gemeindeordnung und der Hauptsatzung vom 24.

    Damit erreichte Wiesbaden 1905 erstmals den Status einer Großstadt, den die Stadt zwischen 1917
    und 1919 kurzzeitig wieder verlor.
    Die höchste Kaufkraft unter den Stadtteilen besitzt Sonnenberg mit ca.
    Damit ist Wiesbaden die zehntwohlhabendste Großstadt Deutschlands sowie die zweitwohlhabendste Großstadt
    in Hessen nach Frankfurt (24.310 Euro). Vorsitzende des Jugendparlaments ist Musa Yolver (Stand
    September 2024).

    References:
    https://online-spielhallen.de/boaboa-casino-cashback-alles-was-sie-wissen-mussen/

  23. Für alle Geräte verpflichten wir uns, verantwortungsvolle,
    sichere und unterhaltsame Casino-Unterhaltung zu bieten.
    Wenn Sie regelmäßig teilnehmen, können Sie
    Sonderangebote erhalten. Beispielsweise erfordern viele Boni eine Mindesteinzahlung von €20,
    können nur für bestimmte Spiele verwendet werden und
    haben Wettanforderungen, die sich von Angebot zu Angebot ändern.
    Unsere Statistiken belegen, dass aktive Spieler durchschnittlich 25% mehr Bonusguthaben pro Monat
    erhalten als Gelegenheitsspieler. Unser WinSpirit No Deposit Bonus Code System bietet Ihnen die Möglichkeit, ohne eigenes Risiko zu spielen. Bei der zweiten Einzahlung ist
    eine Mindesteinzahlung von 40 € nötig, um den 200 % Bonus zu erhalten. Damit Sie die Prämie erhalten, ist jedoch eine Mindesteinzahlung in Höhe von 20
    € notwendig. Neue Spieler im Zoome Casino können einen fantastischen 120% Bonus von bis zu 1000 EUR bei einer Mindesteinzahlung von 20 EUR
    genießen, plus eine aufregende Zugabe von 120 Freispiele.

    Bei der Erstellung des Sicherheitsindex eines betreffenden Casinos verwenden wir eine komplexe Berechnungsformel,
    die alle gesammelten Daten berücksichtigt, die wir bei unserer
    Überprüfung erhoben haben. WinSpirit Casino hat einen hohen Sicherheitsindex von 8.9 erzielt, was es im Hinblick auf Fairness und Spielersicherheit für
    die meisten Spieler zu einer empfehlenswerten Option macht.
    Durch seine Arbeit möchte er sicherstellen, dass Spieler gut informiert sind und
    die besten Entscheidungen treffen können. Mit der ersten Einzahlung aktivierst du so 100% Bonus bis zu
    200€ und 100 Freispiele.

    References:
    https://online-spielhallen.de/die-bwin-casino-mobile-app-dein-ultimativer-guide/

LAISSER UN COMMENTAIRE

Please enter your comment!
Please enter your name here

SÉLECTION DE L'EDITEUR

ARTICLES POPULAIRES

CATÉGORIE POPULAIRE

Sys Advisor © 2015-2021 • Sys Advisor, Tous droits réservés
Licence Creative Commons   Comodo Trusted Site Seal