Set or change the database collation


To set or change the database collation

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.
  2. If you are creating a new database, right-click Databases and then click New Database. If you do not want the default collation, click the Options page, and select a collation from the Collation drop-down list.Alternatively, 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.
  3. After you are finished, click OK.
Advertisements

2 thoughts on “Set or change the database collation

  1. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your weblog?

    My blog site is in the exact same area of interest as yours and my users would genuinely benefit from some of the information
    you present here. Please let me know if this alright with
    you. Thanks a lot!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s