I installed SQL Server 2005 on a machine named "hardName" and then tested the install. We then made a DNS alias so the machine could be referenced as "easyName." I have corrected @@servername via
a) select @@servername
b) sp_dropserver oldName
c) sp_addserver newName,local
d) Bounce the server.
e) select @@servername
The question is, how can I correct serverproperty('servername') without changing the machine's physical name? The system administrators want to reference the computer via "hardName" but the users prefer "easyName."
One of the reasons for this process was because an old machine "easyName" was up during the install and during the migration of databases from "easyName" to "hardName." Now that the migration is complete, I want to finish renaming the database instance.
We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…