How to Update SQL SERVER 2012 Collation

If you have installed the SQL SERVER 2012 but had setup a different collation, here are the steps to change it:

1. Locate the install folder in the Program files. Usually it is in this folder:

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

2.Open the Command Prompt

3. Change Directory to the one above (or where the setup is stored).

4. Run the Script below in the command prompt:

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLCOLLATION=Latin1_General_CI_AS /SQLSYSADMINACCOUNTS=[username] /SAPWD=[Password]

5. Ensure that the [username] and [Password] are your system administrator account credentials.

6. After running the command, the SQL Server's collation is changed.

How To Turn off Start up Applications in Windows

This procedure helps you turn off unwanted applications during Windows Start up.

The steps below demonstrates how to do it in Windows 7.

1. Go to Start .
2. Type MSCONFIG.

3. The System Configuration tool will be launched. In that tool, go to Startup tab, and uncheck the applications that you don't want to load during start up.

4. Click ok once you are done.
5. Click the restart button to apply the changes.