Set or Change DB Collation

Set or Change DB Collation

How to Set or Change the Database Collation using SQL Server Management studio

Default MS SQL 2008 collations - http://puu.sh/lJvpI.txt
Other collations - http://puu.sh/lJvG0.txt
  1. Before proceeding with any changes, first initiate a full backup of client’s DB. Then, prompt them for a full name of the collation they want to set up.
  2. In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.
  3. If the database already exists, right-click the database that you want and click Properties. Click the Options page, and select a collation from the Collation drop-down list.
    Note: do not change the collation until client verifies its full name from the drop down list selected matches exactly or their DB will be lost completely.
  4. After you are finished, click OK.

    • Related Articles

    • MSAcess DB access

      I would recommend that you import your MS-Access database into a sole MSSQL database (as MS-Access is now considered obsolete anyway) you can use any of the following ways; ...

    • Reset mysql password

      First try to see if you can login to mysql as root. ssh to root user, or su root from AD login.       mysql If you get an error similar to: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Then the password is ...

    • How To Set Up ProFTPD on CentOS 6

      How To Set Up ProFTPD on CentOS 6 Download the EPEL repository that will allow us to install proftpd daemon on our VPS. # rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm   Next, install proftpd  with yum # yum ...

    • change permissions of all Folders and Subfolders (also works for files)

      To set the permissions of all files and subfiles, or folders and subfolders run the following: Folders: find . -type d -exec chmod 0755 {} \;  - Finds all units that are folders and changes permissions to 755 Files: find . -type f -exec chmod 0644 {} ...

    • How To Set Up a Firewall Using FirewallD on CentOS 7

      Introduction Firewalld is a complete firewall solution available by default on CentOS 7 servers. In this guide, we will cover how to set up a firewall for your server and show you the basics of managing the firewall with the firewall-cmd ...